sum total of same cell in all worksheets

  • Thread starter Thread starter booshi
  • Start date Start date
B

booshi

I have 50 sheets and each consists of a 6x7 table. Iwant to make a master
sheet with a table to show the sum total of all other sheets.
Is there a formula that I can sum up all values that appear on the same cell
in each sheet?

Thanks
 
Booshi,

=SUM(Sheet1:Sheet50!D1) sums the cells D1 on all sheets, from sheet1 up to
sheet50.
Sheets not between those two will not be counted.


If you sheetnames contain spaces you should make this : =SUM('Sheet
1:Sheet 50'!D1)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
All you need to do is create one giant SUM formula for one of the
cells (say the top left one in your 6x7 grid). Then drag this formula
down/across the master table and the cell addresses will adjust. I
tried this on a simple 2x3 table on two sheets and had a 3rd master
sheet which contained the sum of cells on Sheet1:A1 + Sheet2:A1,
Sheet1:A2 + Sheet2:A2, etc.

On the Master sheet if the table starts in A1 do this:

=SUM(Sheet1!A1+Sheet2!A1)

Then just drag this formula down as many rows as you need (and across
the cols). The cell addresses will adjust just fine.

Deb
 
Back
Top