Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Excel returnes #Value!

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel returnes #Value!

Reply to Message Icon

Name: Pandora
Date: January 27, 2009 at 14:32:42 Pacific
OS: Windows XP
Subcategory: Microsoft Office
Comment:

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



Sponsored Link
Ads by Google

Response Number 1
Name: RTAdams89
Date: January 27, 2009 at 14:45:17 Pacific
Reply:

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


0

Response Number 2
Name: Bryco
Date: January 28, 2009 at 07:07:48 Pacific
Reply:

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


0

Response Number 3
Name: Jennifer SUMN
Date: January 28, 2009 at 10:34:47 Pacific
Reply:

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


0

Response Number 4
Name: jon_k
Date: January 30, 2009 at 04:21:54 Pacific
Reply:

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


0

Response Number 5
Name: seawatch
Date: January 30, 2009 at 16:03:46 Pacific
Reply:

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


0

Related Posts

See More



Response Number 6
Name: RTAdams89
Date: January 31, 2009 at 20:12:42 Pacific
Reply:

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


0

Sponsored Link
Ads by Google
Reply to Message Icon

excel date if then statem... lotus notes error



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Excel returnes #Value!
Excel Find/Search returns #VALUE www.computing.net/answers/office/excel-findsearch-returns-value/4492.html

Excel: Return value based on another value www.computing.net/answers/office/excel-return-value-based-on-another-value/9497.html

Excel numebr formatting issues www.computing.net/answers/office/excel-numebr-formatting-issues/1675.html