Summing of Two cells does not sum!!

[Joe D]

I am setting up a monthly chart and all I am trying to do is a simple SUM
formula. I set it up fine but every time I enter a value it does not add it
in the cell I put the formula in.

Example:
Here is the exact formula I am using =SUM(C6,C8). (Trying for the sum in C10)

It will sum if I already have numbers in it but if I change the numbers or
start with no numbers it does not add it.

[Bob Phillips]

Do you have manual calculation set? Tools>Options>Calculation. Make sure the
Automatic button is set.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joe D" <Joe D@discussions.microsoft.com> wrote in message
news:102BDCC6-75F2-49D9-A785-709158DCCF63@microsoft.com...
> I am setting up a monthly chart and all I am trying to do is a simple SUM
> formula. I set it up fine but every time I enter a value it does not add
it
> in the cell I put the formula in.
>
> Example:
> Here is the exact formula I am using =SUM(C6,C8). (Trying for the sum in
C10)
>
> It will sum if I already have numbers in it but if I change the numbers or
> start with no numbers it does not add it.

[Norman Jones]

Hi Joe,

Try,

Tools | Options | Calculation | select the automatic option | OK


---
Regards,
Norman



"Joe D" <Joe D@discussions.microsoft.com> wrote in message
news:102BDCC6-75F2-49D9-A785-709158DCCF63@microsoft.com...
>I am setting up a monthly chart and all I am trying to do is a simple SUM
> formula. I set it up fine but every time I enter a value it does not add
> it
> in the cell I put the formula in.
>
> Example:
> Here is the exact formula I am using =SUM(C6,C8). (Trying for the sum in
> C10)
>
> It will sum if I already have numbers in it but if I change the numbers or
> start with no numbers it does not add it.