I agree. I got sloppy

"Duke Carey" wrote:

maybe countif() instead of sumif()??

"bj" wrote:

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)

"Allen7575" wrote:

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?