advanced percentage function

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
 
M

Mike H

Try this formatted as %

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

Mike
 
S

Shane Devenshire

Hi,

In 2007 you can use

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top