advanced percentage function
Hi,
In 2007 you can use
=COUNTIFS(A1:A8,"ADP",B1:B8,"W")/COUNTIF(A1:A8,"ADP")
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"EG" wrote:
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
|