| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Summing same cells in multiple worksheets
Hi,
I have a monthly workbook which consists of a worksheet for each day. These sheets are named 01, 02, 03 etc up to 31. I also have a monthly totals worksheet. I want to sum certain cells on each sheet to show in the monthly sheet.... eg ='01'!E7+'02'!E7+'03'!E7....... Is there a quick way of creating this formula without manually typing it in? Thanks in advance Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing across multiple worksheets | Excel Worksheet Functions | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Summing specific cells on two worksheets | Excel Discussion (Misc queries) | |||
| Summing specific cells on two worksheets | Excel Worksheet Functions | |||
| Summing same cell/cells from multiple sheets | Excel Worksheet Functions | |||
Linear Mode
