Adding data from cells in multiple worksheets

  • Thread starter Thread starter Andy Hall
  • Start date Start date
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.
 
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)
 
Back
Top