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

=AVERAGE(IF(<condition,rng))

where rng is your range of cells.

In article ,
"Flutie99" wrote:

Since there isn't an averageif, what is the best way to average a particular
set of numbers? Thanks.