Find sum across all worksheets

[Guest]

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

 

[Peo Sjoblom]

=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

 

[SteveG]

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

 

[Guest]

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