what do you mean "average of passes to fails"?

There will be a single discrete number of passes, and a single discrete
number of failures. What is there to average?

If you mean the *ratio* of passes to fails, assuming

C1: =IF(A150,"pass","fail"), or

C1: =IF(A1="","",IF(A150,"pass","fail"))

Then

C20: =COUNTIF(C1:C19,"pass")/COUNTIF(C1:C19,"fail")

or if you mean the ratio of passes to total attempts:

C20: =COUNTIF(C1:C19,"pass")/SUM(COUNTIF(C1:C19,{"pass","fail"}))



In article ,
"Tricia" wrote:

Hi how would I set up a column to give the average of pass to fail rate?
i.e. if A1 50 then put pass in C3 else put fail then give the average of
passes to fails in cell C20 if there were 19 rows?