Sum accross sheets
Terry
exactly as you describe:
=SUM(Sheet2:Sheet13!C3)
=SUM(January:December!C3)
Type in =SUM(
Select the first sheet (January)
Shift and select the last sheet (December)
Select the cell
close the bracket
press enter
Drag across/down, whatever.
Regards
Trevor
"Terry VanDuzee" wrote in message
...
Hello
I know that as a worksheet function I can sum a cell on each sheet using
=Sum(Sheet1!D4,Sheet2!D4) etc...
However, programmatically, it's bound to be unnecessary.
Im creating a summary sheet where it summarizes each month's value from a
particular cell (all cells across the sheets are the same cell).
EX: In each sheet (Named January to December), in Cell B4:D4 I have
values.
Range B4:B10 have values, C4:C10 have values, D4:D10 have values (on all
sheets).
On my summary sheet, I need to sum all the B4's into 1 cell, All the C4's
in
1 cell etc etc etc.
In essence: Sum(January:December!B4) in Cell B4 on the summary sheet,
Sum(January:December!C4) etc etc.
How can I do this?
Thank you so much
Terry V
|