E
EG
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
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