Summing of Two cells does not sum!!

J

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.
 
B

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)
 
Top