Function THat wIll Add COntents Acorss Worksheets

[Triptanes]

In cell A5on Sheet1, place a formula or function that will add the contents of cell Z100 on all the sheets.

How?

[Biff]

Hi!

One way:

Insert a blank worksheet and move it so that it is the first tab** and name
it START.
Insert another blank worksheet and move it so that it is the last tab and
name it END.

Then your formula would be:

=SUM(Start:End!Z100)

Any sheet that's inserted or moved and is between START and END will be
included in the formula.

If your formula is on Sheet1 and you don't want Sheet1 to be included in
this calculation then move the START sheet to the immediate right of sheet1.
(so that it's the 2nd tab and Sheet1 is the 1st tab).

Biff

"Triptanes" <[email protected]> wrote
in message news:[email protected]...
>
> In cell A5on Sheet1, place a formula or function that will add the
> contents of cell Z100 on all the sheets.
>
> How?
>
>
>
>
> --
> Triptanes
> ------------------------------------------------------------------------
> Triptanes's Profile:
> http://www.excelforum.com/member.php...o&userid=33849
> View this thread: http://www.excelforum.com/showthread...hreadid=536268
>

[Triptanes]

Thank you very much sir, you are magnanimous!

[Biff]

You're welcome!

Biff

"Triptanes" <[email protected]> wrote
in message news:[email protected]...
>
> Thank you very much sir, you are magnanimous!
>
>
> --
> Triptanes
> ------------------------------------------------------------------------
> Triptanes's Profile:
> http://www.excelforum.com/member.php...o&userid=33849
> View this thread: http://www.excelforum.com/showthread...hreadid=536268
>