Count Formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tmerton - 17 Mar 2006 21:01 GMT

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?

Reply to this Message

Elkar - 17 Mar 2006 21:23 GMT

Try this:

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

HTH,
Elkar

> This should be pretty easy - I just can't seem to figure it out...
>
[quoted text clipped - 4 lines]
>
> Help?!

Reply to this Message

tmerton - 17 Mar 2006 21:51 GMT

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?..

Reply to this Message

David McRitchie - 18 Mar 2006 00:13 GMT

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

> This is the formula I am using:
> =COUNTIF(R16:R44,"Y")/COUNTA(R16:R44)
[quoted text clipped - 10 lines]
>
> Any suggestions?...

Reply to this Message