Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum calculation
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum calculation
Your vales ARE text, although they look like numbers.
Select an empty cell. EditCopy. Select your "numbers" EditPaste special, check Add Now they ARE numbers -- Kind regards, Niek Otten "Laura" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum calculation
sum should have an equal sign before it:
=Sum(R122,R183) the cell should be formatted as General. Prior to entering the formula. -- Regards, Tom Ogilvy "Laura" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum calculation
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 SpecialAddOKEsc. Should now be real numbers. Gord Dibben Excel MVP On Tue, 20 Dec 2005 10:55:04 -0800, "Laura" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation in left corner | Excel Worksheet Functions | |||
Equity buildup calculation | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |