I cannot see the result of a SUM in the worksheet, why?

[Nrippe]

I dio have a simple argument (Sum A17:L17). I cannot see the result in the
worksheet, however when I go through the function toolbar the result is
correct. Do you know what is causing this problem?

[Office Helper]

Does the cell look like this: =sum(A17:L17)?



"Nrippe" wrote:

> I dio have a simple argument (Sum A17:L17). I cannot see the result in the
> worksheet, however when I go through the function toolbar the result is
> correct. Do you know what is causing this problem?

[swatsp0p]

It is possible that your sheet is set to manual calculation. Press F9...does the sum now appear? If so, click Tools>Options and click the Calculation tab... make sure that Automatic is ticked.

HTH

Bruce

[Nrippe]

Yes, it does. I revise it many times wondering also about the = sign

"Office Helper" wrote:

> Does the cell look like this: =sum(A17:L17)?
>
>
>
> "Nrippe" wrote:
>
> > I dio have a simple argument (Sum A17:L17). I cannot see the result in the
> > worksheet, however when I go through the function toolbar the result is
> > correct. Do you know what is causing this problem?

[Nrippe]

Great! I will try that, thanks.


"swatsp0p" wrote:

>
> It is possible that your sheet is set to manual calculation. Press
> F9...does the sum now appear? If so, click Tools>Options and click the
> Calculation tab... make sure that Automatic is ticked.
>
> HTH
>
> Bruce
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=567699
>
>

[Nrippe]

No, I checked, it's automatic.

"swatsp0p" wrote:

>
> It is possible that your sheet is set to manual calculation. Press
> F9...does the sum now appear? If so, click Tools>Options and click the
> Calculation tab... make sure that Automatic is ticked.
>
> HTH
>
> Bruce
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=567699
>
>