sum calculation

L

Laura

I am trying to do a project budget and I'm adding 2 cells that are not next
to each other in the spreadsheet. I do the automatic sum calculation with
this formula- Sum(R122,R183). A non value appears.
I did the long version of picking it through the Insert Function box. The
cells are chosen, and the formula result displays the correct total of the
two boxes. Click OK and the non value appears.
 
N

Niek Otten

Your vales ARE text, although they look like numbers.
Select an empty cell. Edit>Copy.
Select your "numbers"
Edit>Paste special, check Add
Now they ARE numbers
 
T

Tom Ogilvy

sum should have an equal sign before it:

=Sum(R122,R183)

the cell should be formatted as General. Prior to entering the formula.
 
G

Gord Dibben

Laura

"Non value" meaning 0 or what?

Very possible your "numbers" in R122 and R183 are text.

Format as General then copy an empty cell(also formatted as General).

Select R122 and R183 and Paste Special>Add>OK>Esc.

Should now be real numbers.


Gord Dibben Excel MVP
 
Top