Sum up a particlar cell in multiple Excel worksheets within same b

L

lpsung

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

bpeltzer

=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).
 
Top