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) ?

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) ?