formula won't work

[tink13ub]

Can someone tell me why this formula won't work in cell A189?
=SUM(A44+A88+A146+A152+A171) Zero just keeps coming up as the
answer.

Each one of these cells contain a sum formula too for example:
A44 is =SUM(A3:A43)

Thanks
Linette

[Max]

Think your formula in A189
> =SUM(A44+A88+A146+A152+A171)

is a little superfluous and
should be amended to either:

=A44+A88+A146+A152+A171

or

=SUM(A44,A88,A146,A152,A171)

As to why
> Zero just keeps coming up as the answer ..

Pehaps calc mode is accidentally set to manual ?

Try pressing F9, does it now compute properly?

To quickly check / change the calc mode:
Click Tools > Options > Calculation tab
Ensure "Automatic" is checked > OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"tink13ub" <tink13ub@discussions.microsoft.com> wrote in message
news:D3244F6A-3C6C-44C5-AF87-E558E59C404C@microsoft.com...
> Can someone tell me why this formula won't work in cell A189?
> =SUM(A44+A88+A146+A152+A171) > answer.
>
> Each one of these cells contain a sum formula too for example:
> A44 is =SUM(A3:A43)
>
> Thanks
> Linette
>