Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing of Two cells does not sum!!
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. |
#2
|
|||
|
|||
Do you have manual calculation set? ToolsOptionsCalculation. Make sure the
Automatic button is set. -- HTH RP (remove nothere from the email address if mailing direct) "Joe D" <Joe wrote in message ... 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. |
#3
|
|||
|
|||
Hi Joe,
Try, Tools | Options | Calculation | select the automatic option | OK --- Regards, Norman "Joe D" <Joe wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |