averageif

N

name

Is there an equivalent to sumif for average, i.e. averageif? If not, d
you know of any simple solutions?

I was thinking of creating a separate row to hold the relevant dat
subset. Using an if statement, I would blank out ("") all the value
from the original data set not needed for the average calculation. An
then just calculate the average on the new data subset. I figured
however, that there was probably a more desirable way to do this. An
help is appreciated
 
B

Bob Phillips

=AVERAGE(IF(rng1=condition,rng2))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Top