advanced percentage function

[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

 

[Mike H]

Try this formatted as %

=SUMPRODUCT((A1:A20="adp")*(B1:B20="w"))/COUNTIF(A1:A20,"ADP")

Mike

 

[Shane Devenshire]

Hi,

In 2007 you can use

=COUNTIFS(A1:A8,"ADP",B1:B8,"W")/COUNTIF(A1:A8,"ADP")