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

G

Guest

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum same cell/range of multiple worksheets within a workbook... 2
Sum Multiple Worksheets, same named cell 1
SUM function across multiple worksheets within one workbook 4
summing same cell in multiple worksheets 3
Totaling cells in multiple worksheets 4
Identical Cells in Multiple Worksheets in one Workbook. 4
How do I find like data in multiple worksheets? 1
sum accross worksheets using names 1

Top