| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
the sum of cells of many sheets
I have approx 150 sheets named with my customers name. I want to create a
cell that shows the sum of C12 in each sheet. Each of my clients has a number in C12 that shows the "Hours Required". I am trying to obtain a total of all hours for all clients. ='Doe, John'!C12+'Smith, Jane'!C12 Works fine for a few sheets but what if I have 150 sheets? What is the formula? I have also tried =SUM('Doe, John'!C12:'Smith, Jane'!C12) This gives me "$VALUE!" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sum up the c13 cells in all of the sheets in a workbook | Excel Discussion (Misc queries) | |||
| add cells together from different sheets within a workbook | Excel Worksheet Functions | |||
| please help with formula for same cells in different sheets | Excel Worksheet Functions | |||
| Linking Cells from different sheets | Excel Discussion (Misc queries) | |||
| cells and sheets, names | Excel Worksheet Functions | |||
![Jeff Klein[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
