Hollywoood
Board Regular
- Joined
- Aug 11, 2011
- Messages
- 53
Hi all,
I have created a survey template for tracking data and since I will use this template for several different individuals I created one copy, named all of the relevant cells I wish to track and then simply created copies of the original sheet so all of the references stay intact.
Now what I would like to do is sum values across all of these sheets. I was hoping I could do something along the lines of
=sum(start:end!Age)
where start is a blank sheet that is first in my workbook and end similarly at the end, and age is a defined cell in each worksheet BUT it isnt necessarily the same cell in each sheet so I cant use a direct cell reference.
Is there something I am missing? I have too many sheets and data points to list each sheet in the sum ie) =sum(steve!Age,John!Age..) etc Is what I am trying to do possible? I am using 2003.
Thanks!
I have created a survey template for tracking data and since I will use this template for several different individuals I created one copy, named all of the relevant cells I wish to track and then simply created copies of the original sheet so all of the references stay intact.
Now what I would like to do is sum values across all of these sheets. I was hoping I could do something along the lines of
=sum(start:end!Age)
where start is a blank sheet that is first in my workbook and end similarly at the end, and age is a defined cell in each worksheet BUT it isnt necessarily the same cell in each sheet so I cant use a direct cell reference.
Is there something I am missing? I have too many sheets and data points to list each sheet in the sum ie) =sum(steve!Age,John!Age..) etc Is what I am trying to do possible? I am using 2003.
Thanks!
