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)
 
Back
Top