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

[NeedToKnowBasis]

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

 

[Bernie Deitrick]

Use SUMIF() / COUNTIF()


HTH,
Bernie
MS Excel MVP

 

[David Biddulph]

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