Calculating Percentages in a Range

A

Allen7575

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

bj

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)
 
D

Duke Carey

maybe countif() instead of sumif()??

bj said:
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)
Click to expand...
 
Top