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

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.comPaid Tech Support: Black Diamond

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

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

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

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

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.comPaid Tech Support: Black Diamond

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History