Eli,

Simply use SUMIF/COUNTIF using the same criteria.

HTH,
Bernie
MS Excel MVP


"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