Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for % of "yes" in range of cells?
How do I write a formula to determine a % of "yes" responses for a range of
cells. For example: Cells C2-C20, 12 of the 18 cells have "yes" the other 6 have "no". Cell C21 would have the % of yes. Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for % of "yes" in range of cells?
=COUNTIF(C2:C20,"yes")/COUNTA(C2:C20)
and format as a percentage. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "npw" wrote in message ... How do I write a formula to determine a % of "yes" responses for a range of cells. For example: Cells C2-C20, 12 of the 18 cells have "yes" the other 6 have "no". Cell C21 would have the % of yes. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula help for using a range of cells! | Excel Worksheet Functions | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions |