Count Formula?

[tmerton]

This should be pretty easy - I just can't seem to figure it out...

I have a list of people that attended a class each has a "Y" or "N".
want % that attended the class. So - the # attended divided by th
total number possible. It should be a count of "Y"'s divided by count
of the column?...

Help?

 

[Guest]

Try this:

=COUNTIF(A1:A100,"Y")/COUNTA(A1:A100)

HTH,
Elkar

 

[tmerton]

This is the formula I am using:
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44)

The conditional formatting I am using works on most cells but a coupl
are not working i.e.
[/INDENT]0 to .7 = red
[/INDENT].71 to .8 = yellow
[/INDENT].81 above = green

A couple cells are not formatted - I am thinking it has to do w/th
cell being formatted for % vs. decimal pt. and maybe the decimal is ou
by alot.

Any suggestions?..

 

[David McRitchie]

The conditions are read in order so if the first condition is
True it is used, If not the second formulas is checked, if that is not
True then the third formulas is checked.

I am not sure of your layout, but since you say it works for most cases
will assume you selected the cells you want colored and that is probably
only once cell.

Condition 1:
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44) <= .7
Condition 2
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44) <= .8
Condition 3:
=COUNTIF(R16:R44,"Y")/COUNTA(R16:R44) <= 1