hi
how about 2 formulas in one.....
=SUMIF(B2:B10,"X",C2:C10)/COUNTIF(B2:B10,"X")

adjust ranges to suit
Regards
FSt1

"Tags" wrote:

I want to find the average time of cells that only have X in them. For
example:
Name Comercial TIME
Belair X 0:30
York 0:15
Dulaney X 0:45
Providence 0:15
Joppa X 0:55

What formula do I use?