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



On Tue, 26 Sep 2006 19:02:01 -0700, Anakin7279
wrote:

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