Counting the occurrence of "Y" & "N" in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christi - 14 Oct 2008 03:05 GMT

I'm just now trying to learn the COUNTIF function but obviously am having a
problem...

If the cell range is (A5:A370) and I need to count the "Y" 's and the "N"
's with the answer resulting in the following format: YYYY/NNNN what would
I use?

Any help apreciated!

Signature

~Christi

Reply to this Message

Max - 14 Oct 2008 03:16 GMT

=REPT("Y",COUNTIF(A5:A370,"Y"))&"/"&REPT("N",COUNTIF(A5:A370,"N"))

Signature

Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---

> I'm just now trying to learn the COUNTIF function but obviously am having a
> problem...
[quoted text clipped - 4 lines]
>
> Any help apreciated!

Reply to this Message

ShaneDevenshire - 14 Oct 2008 03:17 GMT

Hi,

Try this:

=COUNTIF(A5:A370,"Y")&"/"&COUNTIF(A5:A370,"N")

However if your really trying to get the ratio
=COUNTIF(A5:A370,"Y")/COUNTIF(A5:A370,"N")

Might be sufficient. You can force the display of as many digits as you
want by using the custom format code:

# ????/????

In this case it would display up to 4 digits/ 4 digits

Signature

Thanks,
Shane Devenshire

> I'm just now trying to learn the COUNTIF function but obviously am having a
> problem...
[quoted text clipped - 4 lines]
>
> Any help apreciated!

Reply to this Message

Dave Peterson - 14 Oct 2008 03:17 GMT

=rept("y",countif(a5:a370,"y"))&"/"&rept("n",countif(a5:a370,"n"))

You really want:

yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy/nnnnnnnnnnnnnn

or maybe:

=countif(a5:a370,"y")&"/"&countif(a5:a370,"n")

to see something like:
140/139

> I'm just now trying to learn the COUNTIF function but obviously am having a
> problem...
[quoted text clipped - 6 lines]
> --
> ~Christi

Signature

Dave Peterson

Reply to this Message

Christi - 14 Oct 2008 03:39 GMT

Thanks fella's! I knew this was my best chance. :0)

Signature

~Christi

> =rept("y",countif(a5:a370,"y"))&"/"&rept("n",countif(a5:a370,"n"))
>
[quoted text clipped - 19 lines]
> > --
> > ~Christi

Reply to this Message

Max - 14 Oct 2008 08:24 GMT

Aha, I focused on this part in your orig. post, wrongly it seems:

> .. with the answer resulting in the following format: YYYY/NNNN

Signature

Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---

Reply to this Message