sum total of same cell in all worksheets

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
 
A

A.W.J. Ales

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 *
 
D

Deb

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
 
Top