Sum a range across multiple sheets

C

CarlosAntenna

I have a workbook with multiple sheets.
The sheets are named "First", 1, 2, 3......., "Last" in that order.
On a summary sheet outside of that range I use the formula
=SUM(First!A1:Last!A1) and it gives a #VALUE error. Why?
 
C

CarlosAntenna

Thanks Frank, it works great. I knew it could be done, just couldn't get
the syntax.

Carlos
 
K

Ken Wright

The easiest way is to let Excel build the syntax for you. In your summary sheet
simply type =SUM( then click on A1 on sheet First, hold down SHIFT and then
click on the tab for sheet last, put in the last bracket ) and hit enter.
 
C

CarlosAntenna

I did that but didn't hold the shift key. I selected the first cell then
typed a colon and selected the last cell. Obviously that yielded the wrong
results. Thanks for the tip.

Carlos
 

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 across sheets based on a condition 3
Vary sheet name & sum across multiple sheets 3
SUMIFs across multiple sheets 7
Function To Add across Multiple Sheets with a Twist 9
Sumproduct function multiple sheets 4
How to sum one cell across workbook if nr of worksheets is variabl 2
Indirect Function() - summing across sheets 7
3D summing a named range. 2

Top