Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
advanced percentage function
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
advanced percentage function
Try this formatted as %
=SUMPRODUCT((A1:A20="adp")*(B1:B20="w"))/COUNTIF(A1:A20,"ADP") Mike "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced if function?? | Excel Worksheet Functions | |||
Advanced Function help | Excel Worksheet Functions | |||
Advanced Filters - 'or' function | Excel Discussion (Misc queries) | |||
Advanced IF function | Excel Worksheet Functions | |||
Advanced COUNTIF Function | Excel Worksheet Functions |