Calculating Percentages in a Range

[Guest]

How do I set up an Excel formula that calculates the percentage of "Y"
entries in a range of cells that contains both "Y" and "N" entries?

 

[Guest]

if there are no rersponse answers in the range
try
=sumif(range,"Y")/(sumif(range,"Y")+sumif(range,"N")

If there are only Ys or Ns in the range
=sumif(range,"Y")/counta(range)

 

[Guest]

maybe countif() instead of sumif()??

if there are no rersponse answers in the range
try
=sumif(range,"Y")/(sumif(range,"Y")+sumif(range,"N")

If there are only Ys or Ns in the range
=sumif(range,"Y")/counta(range)

 

[Guest]

I agree. I got sloppy

maybe countif() instead of sumif()??