adding multiple worksheet values

  • Thread starter Thread starter John Orrett
  • Start date Start date
J

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
 
One way

=SUM(January:December!A500)

where A500 is the cell with the totals on each page
 
Hi John,

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

=SUM(January:December!C10)

Otherwise you can address the cells individually like

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

Adjust the references to suit.

HTH
Anders Silven
 
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(January:December!$D$50)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
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
 
Back
Top