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
--
Thanks,
Shane Devenshire


"Christi" wrote:

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!
--
~Christi