pass fail

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?

Thanks Tricia

"Tricia" <[email protected]> wrote in message
news:%[email protected]...
> 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?
>
> Thanks Tricia

Hi in cells C1:C125 I have

=IF(A1>50,"pass","fail")
to
=IF(A125>50,"pass","fail")
how do I get an average of the cells C1:C125

Thanks Tricia

Hi Tricia

(is this homework? - sounds like the sort of problem i set as a revision
exercise)

however, i'm not exactly sure what an an average of passes to fails is but
i'm guessing that the COUNTIF function is the way to go. - if this is
homework stop reading now and go try it



number of passes
=COUNTIF(C1:C19,"pass")

number of fails
=COUNTIF(C1:C19,"fail")

Cheers
JulieD

"Tricia" <[email protected]> wrote in message
news:%[email protected]...
>
> "Tricia" <[email protected]> wrote in message
> news:%[email protected]...
>> 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?
>>
>> Thanks Tricia
>
> Hi in cells C1:C125 I have
>
> =IF(A1>50,"pass","fail")
> to
> =IF(A125>50,"pass","fail")
> how do I get an average of the cells C1:C125
>
> Thanks Tricia
>

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(A1>50,"pass","fail"), or

C1: =IF(A1="","",IF(A1>50,"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 <#[email protected]>,
"Tricia" <[email protected]> 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?