Fix #VALUE

K

Kanneberg

I have a row of #VALUE! references in a spreadsheet that is very long. I
checked to make sure that I'm not trying to sum numbers with text, etc. The
formula that I'm using is a formula that looks like this ...
=ROUND(c21+c34+c59,0). The spreadsheet is loaded with other formulas just
like this that are working. Please help.
 
A

Aladin Akyurek

If one or more cells from c21+c34+c59 house text including formula blanks
(i.e. ""), you'll get #VALUE. Try...

=ROUND(SUM(c21,c34,c59),0)

If any of these cells house #VALUE!, you'll still get #VALUE!.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Use TODAY() function as the criteria in a SUMIF formula 1
Searching the formula (not the value) for a text string 1
How can I print rows that go outside of the page without shrinking the text? 0
How To Rapidly Copy Formulas? 0
Finding the weighted average of text that have been given values 1
Calculate the median value before a specified list 0
Sum data using sumif 3

Top