| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of specific cell from several worksheets
I have a workbook with 12 worksheets, one for each month of the year. I also
want to add a "year to date" worksheet. Is there a simple way to take the sum and/or average of a specific cell, over the 12 month period, and carry it over to the same cell on the YTD worksheet? Example: I have a "total pay" in cell A1, on each of the 12 worksheets. I want the sum of all of the A1 cells to compute in cell A1 on the YTD worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| choose last specific nonblank cell from different worksheets | Excel Discussion (Misc queries) | |||
| Pasting in a specific cell in multiple worksheets | Excel Discussion (Misc queries) | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Retrieving a specific cell from multiple worksheets | Excel Worksheet Functions | |||
| How can I do a lookup to a specific cell on multiple worksheets? | Excel Worksheet Functions | |||
Threaded Mode
