Sum across sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several sheets with the same data format - each
worksheet represents 1 week worth of data. I have a
summary sheet in which I want to have a summary of all the
sheets (Weeks).

How do I write a formula (sum formula) that sums the
values in the same cell (say B1) in each worksheet? I do
not want to create a formula where I click on the cell
from each sheet and add them up.

Jay
 
Hi Jay

=SUM(Sheet1:Sheet52!B2)
Note that the formula considers the sheet placements, not the sheet names. So everything
"to be summed" must be placed between the two sheets.
 
Back
Top