Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum accross sheets
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing specific data accross many sheets in a final sheet cha | Excel Discussion (Misc queries) | |||
adding accross sheets in a workbook | Excel Worksheet Functions | |||
Summing accross sheets | Excel Worksheet Functions | |||
Sumproduct accross multiple sheets | Excel Discussion (Misc queries) | |||
added line won't update accross sheets | Excel Discussion (Misc queries) |