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 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" <tricialal2000@yahoo.co.uk> wrote in message
news:%23ZecUkv$EHA.2572@tk2msftngp13.phx.gbl...
> 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" <tricialal2000@yahoo.co.uk> wrote in message
news:%23FD2a2v$EHA.4092@TK2MSFTNGP09.phx.gbl...
>
> "Tricia" <tricialal2000@yahoo.co.uk> wrote in message
> news:%23ZecUkv$EHA.2572@tk2msftngp13.phx.gbl...
>> 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 <#ZecUkv$EHA.2572@tk2msftngp13.phx.gbl>,
"Tricia" <tricialal2000@yahoo.co.uk> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks