Help on Adding the same cell in different sheets.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a big excel sheet, and I am kinda new at it. How can I get a
sum of the values on 45 different excel sheets? I can only get the sum of
about 15 sheets for so before it says that my formulat is too long. Here is
an example of the formula: =SUM('Service Invoice (45)'!D29+'Service Invoice
(44)'!D29)
I need to get the sum of cell D29 from sheets 1-45.

thanks for your help
 
Hi!

Try this:

=SUM('Service Invoice (1):Service Invoice (45)'!D29)

Any sheets (tabs) that are physically located in between Service Invoice (1)
and Service Invoice (45) will be included in the calculation.

Biff
 
See response to your other posting in excel.misc

Please do not multi-post.

Cross-post if you must, but do not multi-post.

Just serves to fragment responses and can lead to a waste of time and effort for
responders.


Gord Dibben MS Excel MVP
 
Back
Top