Open-ended column on another sheet

philippejj0421

I am using SUM referencing a column on another sheet and I want to get that column to be Open-Ended (so that when new rows are added to the other sheet, they will be automatically be in the new total on my sheet).

Details:

I am adding Hours from a time card sheet. When I stay on the that time-card sheet, Open-ended is easy to do: "=SUM(Hours:Hours)" and any added row is automatically integrated to the total.

But when referencing another sheet, the only option I am given is range of rows and the entry is like "=SUM({Bob's Time Card})"  

So, how can I edit the reference to the other sheet to override the range? 

 

Chris McKay

Hi Philippe,

You're on the right track with =SUM({Bob's Time Card})

What you'll want to do is edit the reference and then in the column you're storing your hours in on your timecard sheet, instead of highlighting the visible rows, click on the column header. This will ensure that not only all the rows in the column are referenced, but that any new rows will also be included.

Kind regards,

Chris McKay