Problem with formula

  • Thread starter Thread starter Greg B
  • Start date Start date
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
 
don't know what you came up with, but this should work for A1

=SUM('1:365'!A1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Feasibility of 365 day workbook??? 4
Excel Is this possible?? 3
Excel VBA - Problem with Closing Print Preview 0
Book with 365 sheets?? 6
Expertise needed! How to count consecutive occurances of values greater than 1 0
Insert Row also adds formulas and moves cursor 2
Mid column sum formulas with varied ranges to sum 17

Back
Top