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

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

--
Don Guillett
SalesAid Software

"eliwaite" wrote in message
...
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