# Excel returnes #Value!

Pandora January 27, 2009 at 14:32:42
Specs: Windows XP
 Using 2007formula is =SUM(C11+E11+G11+I11+K11+M11+O11+Q11+S11+U11+W11+Y11)returns a #VALUE!I'm adding the sum of every other columnI've checked all the cells and they are all for accounting but still getting the #Value! even thou I dragged this formula from the row above. I get the correct results in the row above and in the row below. What is causing this problem??? Thanks

See More: Excel returnes #Value!

#1
January 27, 2009 at 14:45:17
 That is probably because you are using the SUM function wrong. You want to use SUM(A1,A2,A3) not SUM(A1+A2+A3).-Ryan AdamsFree Computer Tips and more:http://RyanTAdams.comPaid Tech Support: Black Diamond

Report •

#2
January 28, 2009 at 07:07:48
 You can use the formula with the "+" symbols versus ",". It works just fine.When you drag that formula down a row it will then SUM cells C12+E12+G12...In which cell is your formula as it relates to your targeted cells?Bryan

Report •

#3
January 28, 2009 at 10:34:47
 How wide is the column? Is it wide enough to properly display the result of the formula?"So won’t you give this man his wingsWhat a shameTo have to beg you to seeWe’re not all the sameWhat a shame" - Shinedown

Report •

Related Solutions

#4
January 30, 2009 at 04:21:54
 RTAdams89 is correct.Excel can't evaluate a + if one of the cells contains an invalid character (e.g. a space).However, if you use sum (A1,A2,A3), spaces will be correctly evaluated to zero.HTH

Report •

#5
January 30, 2009 at 16:03:46
 Go with response #3.Your cells aren't wide enough.The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents. - Nathaniel Borenstein

Report •

#6
January 31, 2009 at 20:12:42
 It is not a column width issue. When Excel can't display all the data in a cell (due to the size) it shows "###". The "#VALUE!" means Excel was unable to evaluate the formula in the cell because one of the inputs is not a number. These error appears if you use plus signs to add up cells, and one of those cells has something other than a number in it. Using the SUM() function with commas separating the cells to add will simply skip any cells that don't contain numbers instead of returning "#VALUE!"-Ryan AdamsFree Computer Tips and more:http://RyanTAdams.comPaid Tech Support: Black Diamond

Report •