Prev: Borders Disappear When Hiding Columns
Next: looping excel macros
From: JasonK on 4 Jan 2010 17:02
TIA

I've got a workbook with 25 sheets. I need a cell in the 25th sheet
to sum the same cell in each of the other 24. I can't figure out a
quick way to write a formula for that. Does anyone know?


I tried to Insert Name and Define and the reference, but I couldn't
make it work. My guess was I was doing it all wrong.

Thanks again,

JasonK


From: Ron de Bruin on 4 Jan 2010 17:10
I like this one on sheet 25
=SUM('*'!A20)


See also the last part of this page
http://www.rondebruin.nl/linksum.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JasonK" <motizer(a)yahoo.com> wrote in message news:g8p4k59nkvv6mf7q50sjoaqiq3aggc0u1v(a)4ax.com...
> TIA
>
> I've got a workbook with 25 sheets. I need a cell in the 25th sheet
> to sum the same cell in each of the other 24. I can't figure out a
> quick way to write a formula for that. Does anyone know?
>
>
> I tried to Insert Name and Define and the reference, but I couldn't
> make it work. My guess was I was doing it all wrong.
>
> Thanks again,
>
> JasonK
>
>
From: JasonK on 4 Jan 2010 17:18
Thanks. so simple. I'll get this figured out some day.

thanks again.

JasonK


On Mon, 4 Jan 2010 23:10:58 +0100, "Ron de Bruin"
<rondebruin(a)kabelfoon.nl> wrote:

>I like this one on sheet 25
>=SUM('*'!A20)
>
>
>See also the last part of this page
>http://www.rondebruin.nl/linksum.htm

From: Dave Peterson on 4 Jan 2010 20:15
You could add two "dummy" sheets--one to the far left and one to the far right.
But don't include that 25th sheet.

Call them Start and Finish.

Then your formula would become:

=sum('start:finish'!c3)

I would lock the cells on those sheets and protect them. You don't want someone
putting something in one of the cells that breaks the formulas.

After you do this, you can play what-if games, too. Just drag a worksheet
outside that "sandwich" and that employee's numbers will be ignored.

Remember to have the total sheet outside the sandwich, too.

JasonK wrote:
>
> TIA
>
> I've got a workbook with 25 sheets. I need a cell in the 25th sheet
> to sum the same cell in each of the other 24. I can't figure out a
> quick way to write a formula for that. Does anyone know?
>
> I tried to Insert Name and Define and the reference, but I couldn't
> make it work. My guess was I was doing it all wrong.
>
> Thanks again,
>
> JasonK

--

Dave Peterson
 | 
Pages: 1
Prev: Borders Disappear When Hiding Columns
Next: looping excel macros