Problem with formula

G

Greg B

Hi I am hoping for some help,

I have been working on spreadsheets for a whole year and I have named the
worksheets 1,2,3 up to 365. On my final sheet I am wanting to have the
totals of all the sheets added up for that particular cell.

I know I can go through and do each one individually or is there a code to
do this?


Thank you
Greg B
 
G

Gary Keramidas

don't know what you came up with, but this should work for A1

=SUM('1:365'!A1)
 
Top