Is there an AVERAGE IF function in Excel?

E

eliwaite

I trying to average one row if another row's value is true. I know there is a
sumif, and a countif, but couldn not find an averageif. If you could let me
know who to do this, that would be wonderful.

Thank you,
Eli
 
B

Bernie Deitrick

Eli,

Simply use SUMIF/COUNTIF using the same criteria.

HTH,
Bernie
MS Excel MVP
 
D

Don Guillett

Yes, it's an array formula which must be entered with ctrl+shift+enter,
something like.

=average(if(a1:a21="J",b1:b21)
 
B

BradHaberman

eliwaite said:
I trying to average one row if another row's value is true. I know ther
is a
sumif, and a countif, but couldn not find an averageif. If you coul
let me
know who to do this, that would be wonderful.

Thank you,
Eli
Click to expand...

How about
IF(*row is true*, average(array), *row not true*)

Where *row is true* is the row being checked and *row not true* is wha
is expected if false ie,. "" for a null string
 
Top