ExcelBanter - Calculating Percentages in a Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculating Percentages in a Range (https://www.excelbanter.com/excel-worksheet-functions/21524-calculating-percentages-range.html)

Allen7575

Calculating Percentages in a Range

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?

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?

Duke Carey

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?

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?

All times are GMT +1. The time now is 01:02 PM.