Help on Adding the same cell in different sheets.

A

Anakin7279

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
 
B

Biff

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
 
G

Gord Dibben

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
 
Top