Adding data from cells in multiple worksheets

A

Andy Hall

What is the formula to add information from cells in
multiple worksheets? For example, if I want to add all the
numbers in the cell C3 in five worksheet and have the
results in a sixth sheet.
 
R

Ron de Bruin

Hi Andy

Add two sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last sheet of your workbook.
this are empty sheets!!!

All worksheets between these sheets will be sum
with this formula

=SUM(start:end!B2)
 

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

move a row of data from one work sheet to another using a formula 1
Summing over multiple worksheets 1
enter data two worksheets but not in the same cell as first 1
Totaling cells in multiple worksheets 4
adding in multiple numbers when on cell is Blank 5
summing values for the same cell in 36 different worksheets 1
Adding VLOOKUPS across multiple worksheets 3
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10

Top