Hi,

Can anyone tell me how to program a cell for the following:

A B
1 ADP W
2 ISM W
3 ADP L
4 DOR W
5 ADP W
6 NHS W
7 ADP W
8 ISM L

In a seperate cell (Say C5), I want a formula that will count the total
number of times ADP appears in Column A and of that total the percentage of
times the corresponding B cell is W for ADP (in this case it would be 75%).
What would be the formula for this?

Thanks for your help!

EG