Totalling cells in multiple spreadsheets

  • Thread starter Thread starter Paul Olson
  • Start date Start date
P

Paul Olson

Hi,

I've got 50 small spreadsheets in a workbook (Excel(97)
which I want to add together in a summary sheet. I could
put in a simple formula =sheet1a5+sheet2a5+sheetxa5 to
find the total of all the A5s in the workbook. The problem
is making sure I have included all the relevant sheets.
Is there a formula I could use that picks up all the
relevant sheets.

Thanks for looking.

Paul
 
Hi Paul

a couple of options ...
1) you could have a look consolidation on the data menu
OR
2) you could click in say cell A5 on the summary sheet and type
=SUM(
then click on sheet1's tab, hold your shift key down and click on the last
sheet tab, then click on cell A5 of the sheet that you can see and press
enter
you should see something like this in the summary cell
=SUM(Sheet1:Sheet50!A5)
(you could just type this in), then you can fill this across & down as
applicable and the cell number will change accordingly.

- option 2 will only work if all your data is in the same cell in each
workbook and if the summary sheet is not between sheet1 & sheet50.

Hope this helps
Cheers
JulieD
 
Back
Top