Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Formula to Know Percent of a row of Pass/Fail data
Please Help! :o) I'm drawing a blank on how to create a formula that will
give you the percent passing on a row of data that has either pass, fail or a blank space. Is there any way to create an IF statement for the calculated percentage? Here's an example: Date 1st shift 2nd shift 6/1/09 pass pass 6/2/09 pass fail 6/3/09 pass 6/4/09 fail fail 6/5/09 fail And it will be calculated per week of data. I thought about giving pass a value of 100 and fail a value of 0, but I don't know if that would really solve anything. Any hints or assistance would be fabulous! Moriah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Formula to Know Percent of a row of Pass/Fail data
Hi,
Maybe this =COUNTIF(B2:B20,"pass")/(COUNTIF(B2:B20,"fail")+COUNTIF(B2:B20,"pass")) format as percentage and for your sample data you get 50% pass rate Mike "Moriah" wrote: Please Help! :o) I'm drawing a blank on how to create a formula that will give you the percent passing on a row of data that has either pass, fail or a blank space. Is there any way to create an IF statement for the calculated percentage? Here's an example: Date 1st shift 2nd shift 6/1/09 pass pass 6/2/09 pass fail 6/3/09 pass 6/4/09 fail fail 6/5/09 fail And it will be calculated per week of data. I thought about giving pass a value of 100 and fail a value of 0, but I don't know if that would really solve anything. Any hints or assistance would be fabulous! Moriah |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Formula to Know Percent of a row of Pass/Fail data
Thanks Mike! I was making it way more difficult than neccessary. :o) It
works great! "Mike H" wrote: Hi, Maybe this =COUNTIF(B2:B20,"pass")/(COUNTIF(B2:B20,"fail")+COUNTIF(B2:B20,"pass")) format as percentage and for your sample data you get 50% pass rate Mike "Moriah" wrote: Please Help! :o) I'm drawing a blank on how to create a formula that will give you the percent passing on a row of data that has either pass, fail or a blank space. Is there any way to create an IF statement for the calculated percentage? Here's an example: Date 1st shift 2nd shift 6/1/09 pass pass 6/2/09 pass fail 6/3/09 pass 6/4/09 fail fail 6/5/09 fail And it will be calculated per week of data. I thought about giving pass a value of 100 and fail a value of 0, but I don't know if that would really solve anything. Any hints or assistance would be fabulous! Moriah |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Formula to Know Percent of a row of Pass/Fail data
Glad I could help
"Moriah" wrote: Thanks Mike! I was making it way more difficult than neccessary. :o) It works great! "Mike H" wrote: Hi, Maybe this =COUNTIF(B2:B20,"pass")/(COUNTIF(B2:B20,"fail")+COUNTIF(B2:B20,"pass")) format as percentage and for your sample data you get 50% pass rate Mike "Moriah" wrote: Please Help! :o) I'm drawing a blank on how to create a formula that will give you the percent passing on a row of data that has either pass, fail or a blank space. Is there any way to create an IF statement for the calculated percentage? Here's an example: Date 1st shift 2nd shift 6/1/09 pass pass 6/2/09 pass fail 6/3/09 pass 6/4/09 fail fail 6/5/09 fail And it will be calculated per week of data. I thought about giving pass a value of 100 and fail a value of 0, but I don't know if that would really solve anything. Any hints or assistance would be fabulous! Moriah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula help - Sum results Pass or Fail | Excel Worksheet Functions | |||
Graphing Text: Pass or Fail | Charts and Charting in Excel | |||
Creating visible Pass / Fail areas | Charts and Charting in Excel | |||
Pass or Fail (green or red) criteria for cell? | Excel Discussion (Misc queries) | |||
pass fail | New Users to Excel |