adding multiple worksheet values

[John Orrett]

Hi all, and excuse the ignorance, but I'm asking this on behalf of a friend.
He has an Excel file with 12 spreadsheets named January to December. Each
spreadsheet has a column of figures which individually tally up on the
bottom of each page using a standard formula.
Is there any way of setting a formula to add up the 12 totals of each
worksheet to give a gross total on the month 12 spreadsheet.
Best wishes,
John

 

[Peo Sjoblom]

One way

=SUM(Januaryecember!A500)

where A500 is the cell with the totals on each page

 

[Anders S]

Hi John,

If the source cells are on the same location (e.g. C10) on each worksheet you can use something like

=SUM(Januaryecember!C10)

Otherwise you can address the cells individually like

=SUM(January!C10,July!C11,December!C12)

Adjust the references to suit.

HTH
Anders Silven

 

[A.W.J. Ales]

Suppose the cells on the various sheet are in different cells

=January!$D$25 + February!$D$50 + .... + December!$D$100
(you don't have to type everything, you can just select the worksheettab
ande the cell).


If they are all in the same cell (say D50) you could use =
Sum(Januaryecember!$D$50)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[John Orrett]

Thanks for the feedback folks. All the values on each worksheet will be in a
different cell, as each month's figures will vary. I will pass on this
information to my friend.
Many thanks for your prompt responses.
Best wishes,
John