Pandora January 27, 2009 at 14:32:42 Specs: Windows XP
Using 2007 formula 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 column I'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
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!"
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.