Problem with formula
 

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

Problem with formula
 

Sorry I have worked it out

Thanks again

Greg

"Greg B" wrote in message
...
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

Problem with formula
 

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

=SUM('1:365'!A1)

--


Gary

"Greg B" wrote in message
...
Sorry I have worked it out

Thanks again

Greg

"Greg B" wrote in message
...
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