Creating a percentage average from yes /no cells

CAS

Hi

I'm trying to use COUNTIF to create a percentage average driven from columns where yes/no/NA are entered can someone help?

Paul Newcome

To get a percentage, you would get the number of cells marked as (for example) "Yes" and divide that by the total number of cells.

=COUNTIFS([Column Name]:[Column Name], @cell = "Yes") / COUNT([Column Name]:[Column Name])

Paul Newcome

To get a percentage, you would get the number of cells marked as (for example) "Yes" and divide that by the total number of cells.

=COUNTIFS([Column Name]:[Column Name], @cell = "Yes") / COUNT([Column Name]:[Column Name])