Thread
:
embedding "ISERROR" function into an "IF" statement
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
external usenet poster
Posts: 733
embedding "ISERROR" function into an "IF" statement
wrote...
I'm trying to add up a column of numbers and some of the cells have
#N/A or #DIV/0! which causes my summation to come up as an error as
well.
I'd like to keep my #N/A's in the cells and use the ISERROR function
and thought it should be embedded into an IF statement. Can any help
me do this?
Don't bother with ISERROR (or ISNUMBER) or IF. Just use
=SUMIF(YourRangeHere,"<0")+SUMIF(YourRangeHere,"0 ")
Reply With Quote
Harlan Grove
View Public Profile
Find all posts by Harlan Grove