Count Formula?
 

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". I
want % that attended the class. So - the # attended divided by the
total number possible. It should be a count of "Y"'s divided by counta
of the column?...

Help?!


--
tmerton
------------------------------------------------------------------------
tmerton's Profile: http://www.excelforum.com/member.php...o&userid=32574
View this thread: http://www.excelforum.com/showthread...hreadid=523732

Count Formula?
 

Try this:

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

HTH,
Elkar

"tmerton" wrote:


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". I
want % that attended the class. So - the # attended divided by the
total number possible. It should be a count of "Y"'s divided by counta
of the column?...

Help?!


--
tmerton
------------------------------------------------------------------------
tmerton's Profile: http://www.excelforum.com/member.php...o&userid=32574
View this thread: http://www.excelforum.com/showthread...hreadid=523732

Count Formula?
 

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 couple
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/the
cell being formatted for % vs. decimal pt. and maybe the decimal is out
by alot.

Any suggestions?...


--
tmerton
------------------------------------------------------------------------
tmerton's Profile: http://www.excelforum.com/member.php...o&userid=32574
View this thread: http://www.excelforum.com/showthread...hreadid=523732

Count Formula?
 

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tmerton" wrote in message
...

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 couple
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/the
cell being formatted for % vs. decimal pt. and maybe the decimal is out
by alot.

Any suggestions?...


--
tmerton
------------------------------------------------------------------------
tmerton's Profile: http://www.excelforum.com/member.php...o&userid=32574
View this thread: http://www.excelforum.com/showthread...hreadid=523732