Getting the sum of the same cell in defferent exel 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
 
Insert a new sheet at beginning of sheets. Name it "First"....no quotes

Insert a new sheet at end of sheets. Name it "Last"........no quotes.

On any sheet enter this formula

=SUM(First:Last!(D29)

This will SUM all D29's on all sheets between First and Last.

When inserting any more new sheets make sure they are between First and Last.


Gord Dibben MS Excel MVP
 
We may as well make this a complete circular reference!

See response to your other post in .Functions

Biff
 

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

Help on Adding the same cell in different sheets. 2
Time format? 1
airline standby worksheet 7
Continuous Invoice Nos. 3
Excel How to add numbers in same cell? 2
sum 1
Summing up various Worksheets to one Summary sheet using variables 1
How do i collate data from different sheets in one sheet? 8

Back
Top