embedding "ISERROR" function into an "IF" statement
Bob Phillips wrote...
Hardly intuitive.
....
"Harlan Grove" wrote in message
....
=SUMIF(YourRangeHere,"<0")+SUMIF(YourRangeHere," 0")
Depends on one's understanding of how SUMIF works. SUMIF with <, <=, ,
= numeric comparisons only sums numbers and excludes error values. In a similar way, COUNTIF can count the instances of particular error values, e.g., =COUNTIF(A:A,"#N/A"). Once one learns how COUNTIF and SUMIF works, maybe then it becomes intuitive.
|