MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum across sheets (easy way?)


Posted by Ross on June 11, 2001 10:34 AM

I know how to write a formula to sum across sheets; for example, =sum(sheet1!a1, sheet2!a1, sheet!a1, etc). Is there an easier way to do this? I tried =sum(sheet1!a1:sheet3!a1), but it doesn't work.


Posted by AB on June 11, 2001 10:47 AM

=SUM(Sheet1:Sheet3!A1)

It's a standard 3D formula reference:

=SUM(Sheet1:Sheet3!A1)

Regards,
Aaron

Posted by Ben O. on June 11, 2001 10:48 AM

You only have to specify the range once, like this:

=SUM(Sheet1:Sheet3!A1)

You can also type in =SUM(, select the range you want to sum on the first sheet, hold down the control button and select the last sheet you want to sum, then type in the end parent, ), and hit enter.

That should work.

-Ben

Posted by Ben O. on June 11, 2001 10:49 AM

Make that the Shift button, not the Ctrl button (n/t)

Posted by Ross on June 11, 2001 11:13 AM

Thanks guys (nm)