If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding cells proplem
i had a cell (C1) called "total" that displays the sum of two other cells..
i.e. the total cell got the formula "=sum(A1+B1)" .. I then typed a value in cell (D1). Then I tried to add C1 to D1 in the cell E1. I used segma sign to add the two cells(C1+D1) or I typed the formula "=sum(C1+D1)" in the cell E1. However, the cell E1 gave a "Value!" error. I don't know why.. when I tried the same in another computer, it worked well I wonder if there is options to make the cell E1 show the result. |
#2
|
|||
|
|||
Adding cells proplem
Is there any reason you are using
=SUM(C1+D1) and not =SUM(C11) ? Regardless the value error happens because you use an operand ( + in this case) and at least one of the values are text, if you use the latter formula you won't get an error since sum ignores text but you won't get the correct result either Make sure both values are number by making sure both cells are formatted as general or number and typing in the values to test. -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "r" wrote in message ... i had a cell (C1) called "total" that displays the sum of two other cells.. i.e. the total cell got the formula "=sum(A1+B1)" .. I then typed a value in cell (D1). Then I tried to add C1 to D1 in the cell E1. I used segma sign to add the two cells(C1+D1) or I typed the formula "=sum(C1+D1)" in the cell E1. However, the cell E1 gave a "Value!" error. I don't know why.. when I tried the same in another computer, it worked well I wonder if there is options to make the cell E1 show the result. |
#3
|
|||
|
|||
Adding cells proplem
sorry. That was a typo in the messege. I ment to type "=sum(C11)"
Any way, you are right.. I have to make both cells formatted as general or number. That was the problem. Thank you "Peo Sjoblom" wrote: Is there any reason you are using =SUM(C1+D1) and not =SUM(C11) ? Regardless the value error happens because you use an operand ( + in this case) and at least one of the values are text, if you use the latter formula you won't get an error since sum ignores text but you won't get the correct result either Make sure both values are number by making sure both cells are formatted as general or number and typing in the values to test. -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "r" wrote in message ... i had a cell (C1) called "total" that displays the sum of two other cells.. i.e. the total cell got the formula "=sum(A1+B1)" .. I then typed a value in cell (D1). Then I tried to add C1 to D1 in the cell E1. I used segma sign to add the two cells(C1+D1) or I typed the formula "=sum(C1+D1)" in the cell E1. However, the cell E1 gave a "Value!" error. I don't know why.. when I tried the same in another computer, it worked well I wonder if there is options to make the cell E1 show the result. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
checking that cells have a value before the workbook will close | kcdonaldson | Worksheet Functions | 8 | December 5th, 2005 04:57 PM |
Adding a value to blank cells | Rugby Al | General Discussion | 2 | December 2nd, 2005 07:54 PM |
adding color to cells based on a formula | fyrfytr265 | Worksheet Functions | 2 | November 1st, 2005 05:17 PM |
Adding up cells that include text in them | Alan | General Discussion | 1 | August 24th, 2005 08:23 PM |
Adding cells with formulas calculating the value | Chris | Setting up and Configuration | 1 | October 15th, 2003 10:59 AM |