Proper use of ISERROR() formula

I've got myself all confused using the ISERROR() formula. Essentially all I want to do is average cells B5:B16, and ignore any cells that are returning an error so I can get a correct average. What exactly is the proper way to do this?

You know, I need to stop asking questions so quickly.

This worked for me: =SUMIF(B5:B16,">0")/COUNTIF(B5:B16,">0")

Hi,

ISERROR will return True or False. IFERROR will let you add a second argument if it is TRUE (like "").

This will tell you if there are any errors

IF(ISERROR(B5:B16),"No errors found","Errors found")

This will average all of the cells with no errors

{=AVERAGE(IFERROR(B2:B16,""))}

Entered as Ctrl+Shift+Enter (not Enter only)

Hope this helps.

abousetta

How about

=AVERAGEIF(B5:B16,">0")