One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF(ISNUMBER(IF(rng<0,rng)),rng))

where rng is your range of interest.

In article ,
Mike wrote:

When I use the average function, I want to ignore values like $0.00, #DIV/0!.
How do I do this?