Gathering totals from various worksheets
Thank you...very helpful!
"BoniM" wrote:
If you're summing the same cell from multiple worksheets in the same workbook:
Select the cell where you want the total to appear, click AutoSum, click on
the first sheet in the range of sheets, hold down the shift key and click on
the last sheet in the range of sheets and then click the cell you want to
total from all sheets. Hit the enter key (or click the enter button on the
formla bar) to complete.
If you were totaling cell B25 from sheets named Jan thru Dec, it would look
like this:
=SUM(Jan:Dec!B25)
If the cells are not in the same location on each sheet, select the cell
where you want the total to appear, type an equal sign, click the sheet tab
of the first sheet that contains a value you want to include in your total
and click the cell that contains that value, type a plus sign and click the
sheet tab for the next value and click that cell, continue until you have
added all your values to the formula and then enter to complete.
Adding B25 from Jan, B22 from Feb, and B28 from Mar would look like this:
=Jan!B25+Feb!B22+Mar!B28
"smooney" wrote:
I want to gather cells from different worksheets and sum them on a separate
sheet. How do you do this? Thanks
|