"AverageIF" alternative
 

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

sumif()divided by countif()

--
Greetings from New Zealand
Bill K

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

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.