Addition involving #VALUE!

[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

 

[Arvi Laanemets]

Hi

The safest way, check function returning #VALUE for error
=IF(ISERROR(YourFunction),"",YourFunction)

 

[Biff]

Hi Ken,

Here's one way:

=SUMIF(A1:A5,">0",A1:A5)

Biff