| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum up a particlar cell in multiple Excel worksheets within same b
Within a workbook in Excel, there are multiple worksheets. How do I sum up a
particular cell (say C10) in each worksheets (say worksheet 1-5) ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum up a particlar cell in multiple Excel worksheets within same b
=sum(Sheet1:Sheet5!C10). Beware that the sheets included in the sum are
based on the sequence of the sheets (thus, if you moved Sheet4 after Sheet5, Sheet4 would be excluded from the sum). "lpsung" wrote: Within a workbook in Excel, there are multiple worksheets. How do I sum up a particular cell (say C10) in each worksheets (say worksheet 1-5) ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, multiple worksheets | Excel Discussion (Misc queries) | |||
| How to sum the values of a single cell from multiple worksheets | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How can I do a lookup to a specific cell on multiple worksheets? | Excel Worksheet Functions | |||
| Excel should allow multiple hyperlinks in a single cell | Excel Discussion (Misc queries) | |||
Linear Mode
