Find sum across all worksheets

[Ang2459]

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


"Ang2459" <[email protected]> wrote in message
news:[email protected]...
>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

[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

[Ang2459]

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
>
>