is there a feature in numbers similar...

Post Reply
Guest

is there a feature in numbers similar...

Post by Guest » Fri Dec 30, 2011 4:39 am

Is there a feature in numbers similar to the 3-d reference in excel whereby it is possible by means of one simple formula to add the contents of the same cell in each sheet of a multiple sheet spreadshet, e.g I want to add the contents of cell h55 on each sheet of a 52 page spreadsheet but wthout having to type in the add function 52 times.

 

Thanks


Guest

Re:is there a feature in numbers similar...

Post by Guest » Fri Dec 30, 2011 4:46 am

Bill,

 

No, there is no such function in Numbers. If you can make a list of your sheets, it would be easy to build a column with 52 expressions that could be summed in a 53rd.

 

Jerry


Guest

Re:is there a feature in numbers similar...

Post by Guest » Fri Dec 30, 2011 5:16 am

Hi Jerry - thanks for the prompt response, I understand what you recommend but really the excel 3-d is a bit more efficient I think!!

Guest

Re:is there a feature in numbers similar...

Post by Guest » Fri Dec 30, 2011 6:52 am

Bill,

 

We're not here to judge or referee, just to try to help Numbers users. Pick the application that works best for you.

 

Jerry


Post Reply