How do I average only if data in another column = "X"?

NeedToKnowBasis · Jan 11, 2008

I know conditional formulas, but can't seem to program an average into an IF
formula.

Bernie Deitrick · Jan 11, 2008

Use SUMIF() / COUNTIF()

HTH,
Bernie
MS Excel MVP

David Biddulph · Jan 11, 2008

What formula are you trying? What error are you getting, or what unexpected
result from what inputs?