Adding over 30 worksheets in a workbook

E

-E

Happy Holidays! How can I SUM the value of the same cell located in over 30
worksheets in the same workbook to get a grand total of all those values? I
currently get a message back stating my formula is too long. Appreciate the
help!
 
E

Eduardo

Hi,
Try,
=SUM(Sheet1:Sheet30!A44)
Change A44 for the cell where the totals are
If this helped you please say yes, thank you and Happy Holidays
 
E

-E

Perhaps I needed to state that each worksheet has a unique name (a person).
I did try going to the first worksheet, held down the shift key, then went to
the last worksheet, then entered the appropriate cell, but it didn't work.

Any further suggestions? Thanks!
 
E

-E

Never mind my previous response. I went back and retried it and it did work!
Thanks so much!!! Happy New Year!
 

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

Insert Existing Worksheets into a new Workbook 2
Excel Count If Formula Question 1
Linking workbook to multiple worksheets 1
Ordering of sheets in a workbook 2
countif function in multiple worksheets 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Search columns on multiple worksheets 2
Calculating Average over many worksheets 1

Top