Addition involving #VALUE!

  • Thread starter Thread starter Ken H
  • Start date Start date
K

Ken H

I am trying to add a series of cells of which one has the
value of "#VALUE!". How do I do this so that the addition
function ignores the cell with the "#VALUE!". I tried the
SUM function and it ignores other text values but doesn't
ignore "#VALUE!".
Thanks - Ken
 
Hi

The safest way, check function returning #VALUE for error
=IF(ISERROR(YourFunction),"",YourFunction)
 
You must log in or register to reply here.

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

XL2002 SUM with a twist... 4
SUM function that ignores "#VALUE" and error entries?? 2
#value error for sumproduct using RIGHT cmd 0
Validation of blank cells 3
Excel Concatenate with line breaks but ignore blank cells 3
SUMIF NOT #VALUE Question 3
Sumproduct Ignore Text 2
If function help 0

Back
Top