sum calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laura - 20 Dec 2005 18:55 GMT

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.

Reply to this Message

Niek Otten - 20 Dec 2005 19:11 GMT

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

Signature

Kind regards,

Niek Otten

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

Reply to this Message

Tom Ogilvy - 20 Dec 2005 19:15 GMT

sum should have an equal sign before it:

=Sum(R122,R183)

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

Signature

Regards,
Tom Ogilvy

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

Reply to this Message

Gord Dibben - 20 Dec 2005 20:46 GMT

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

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

Reply to this Message