Excel question - adding up cell values across worksheets

mwddrwg

Hi all,

I have a an Excel workbook with 12 worksheets and a summary sheet (13 in all). On the summary sheet I want to enter in a cell the values from specific cells on the other 12 sheets.

I can't figure out the formula I need for this. Does changing the names of the sheets from 'Sheet1, Sheet2' etc make any difference to the formula I need?

Sorry for the boring question

Many thanks

rmg1

In short, yes.
The formula you would need is something along the lines of:-
='Sheet1'!A1+'Sheet2'!A1+'Sheet3'!A1+'Sheet3'!A1 ..... etc.

You'll need to change the sheet names to match yours and the cells for the ones you want to add up.

mwddrwg

That sounds great! I'll give it a go and let you know how I get on

Niv

FYI - you know you don't have to type it all out longhand though. All you need to do is type = then go to the cells on each worksheet pressing + in-between each one.

Niv

rmg1

I did, but I wasn't sure if the OP did.
The other good thing about Excel (and there aren't that many) is that if you change the name of the sheet, any formulae that reference it will change accordingly.

Prothet_of_Doom

Be careful. If you link too many tabs, or worksheets together the whole computer grinds to a halt

(Mind you I had about 100 tabs, and 3 sheets all linked, and when you changed one figure it crunched about 5000 cells)

cookie365

If you want something a bit more involved than just adding a single cell across worksheets, have a look at Data Consolidation

http://support.microsoft.com/kb/214270

EchoLocation

rmg1 wrote: »

In short, yes.
The formula you would need is something along the lines of:-
='Sheet1'!A1+'Sheet2'!A1+'Sheet3'!A1+'Sheet3'!A1 ..... etc.

You'll need to change the sheet names to match yours and the cells for the ones you want to add up.

This can be shorted to =SUM(Sheet1:Sheet3!A1) ..... etc.
The worksheets will need to be contiguous though.