How to sum the values of a single cell from multiple worksheets

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

Guest

I have a worksheet for each month and a Year total worksheet. I would like
to sum up the corresponding monthly values into the same cell on the Year
total worksheet. I seem to recall that there is a simple way to do this
but...it's been more that 10 minutes ago.
 
try using the sum formula. For example if the sheets were named Jan, Fe
with values in cells A1 to A10 use =sum('Jan'!A1:A10,'Feb'!A1:A10
 
Let's say you monthly worksheets were name jan, feb, mar,....and year was the
yearly sheet. Your formula for A1 in the year sheet would be:


=jan!A1+feb!A1+mar!A1.....
 
Rat

Enter in your Grand Total cell in sheet1.

=SUM(sheet2:sheet5!B4)

Alternative, which most prefer and lends itself to flexibility in naming,
deleting and moving sheets.

Insert a dummy sheet to the right of the Grand Total sheet. Name it Start

Insert a dummy sheet at end of sheets. Name it End.

In Grand Total sheet enter =SUM(Start:End!B4)

When inserting new sheets make sure they are inserted between Start and End
sheets.


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM 2 cells only if there is a value in both 1
Sum Multiple Worksheets, same named cell 1
Conditional Sum across WORKSHEET 6
Conditional SUM across multiple worksheets 0
SUMIF result including values not specified in sum-range 2
Sum multiple worksheet sales data by month 4
Totalling sequential worksheets 1
Summing same cells in multiple worksheets 1

Back
Top