Count If Formula

8

8675039

Hi,

I am looking for a formula that would calculate one cell if anothe
cell has a letter.

For Example:

A B
1 X 7:00
2 Y 3:25
3 Q :25
4 x :45

I want excel to count in column A and find all of the "x's" and add u
how much time "column b" it took. So I want excel to come up with 7:45
(adding b1 and b4 and any other "x's" that have a time in column b)

Thanks
 
Top