formula to add cells in multiple shts in the same wkbk

G

Guest

Is there a way to add the same cell (ie A1) from multiple worksheets without
manually having to input sum (sheet1A1, sheet2A1, sheet3A1,...)?
 
R

Ron de Bruin

Hi busker

Try this
Put in two dummy sheets(empty sheets) with the name "start" as the first sheet
and one with the name "end" as the last one.


You can use a formula like this then to sum all sheet between start and end
=SUM(start:end!A1)


Another way is to create links to a cell in each sheet and sum them
see http://www.rondebruin.nl/summary.htm
 
G

Guest

If the source sheets are consecutive , use a 3D sum:
=sum('Sheet1A1:Sheet3Z9'!A1) will add up all the A1 cells from Sheet1A1
through Sheet3Z9 (based on the order in which the sheets appear in the
workbook).
 

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

Excel How to add numbers in same cell? 2
summing same cell in multiple worksheets 3
Inerting name of current worksheet into fuction 11
matching values between worksheets 8
Hiding Formula Answers in Specific Cells 1
Linking Totals Across Multiple Worksheets 2
Average Cells in Multiple Worksheets 10
Sum Multiple Worksheets, same named cell 1

Top