Excel returnes #Value!

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

See More: Excel returnes #Value!

Report •


#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 Adams
Free Computer Tips and more:http://RyanTAdams.com

Paid 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 wings
What a shame
To have to beg you to see
We’re not all the same
What 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 Adams
Free Computer Tips and more:http://RyanTAdams.com

Paid Tech Support: Black Diamond


Report •


Ask Question