Find sum across all worksheets
 

I have 42 worksheets in a workbook and i want to create a summary worksheet
at the end. I need to add up the same cell on each worksheet for the summary
page. Example: A sum of all E4's in the worksheet. There is to many
worksheets for the formula to fit. Thanks

Find sum across all worksheets
 

=SUM(first:last!E4)

let excel do the work

type

=SUM(

click the first sheet tab, hold down shift and click the last sheet tab,
click in E4 and press enter


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Ang2459" wrote in message
...
I have 42 worksheets in a workbook and i want to create a summary worksheet
at the end. I need to add up the same cell on each worksheet for the
summary
page. Example: A sum of all E4's in the worksheet. There is to many
worksheets for the formula to fit. Thanks

Find sum across all worksheets
 

In the cell of your summary sheet, type "=SUM(" . Select the first
worksheet to start summing from say sheet 2. Depress the shift key and
select the last worksheet to sum say sheet 42 then select the E4 and hit
enter. Your formula will look like this.

=SUM(Sheet2:Sheet42!A1)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530598

Find sum across all worksheets
 

Awesome! thanks so much. You made my day a lot easier!

"SteveG" wrote:


In the cell of your summary sheet, type "=SUM(" . Select the first
worksheet to start summing from say sheet 2. Depress the shift key and
select the last worksheet to sum say sheet 42 then select the E4 and hit
enter. Your formula will look like this.

=SUM(Sheet2:Sheet42!A1)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530598