Counting "Yes" and "No" within a column - receiving blocked error

SNickNBCUniUSH

Hello,

I'm trying to count both the number of "Yes" and "No" in a column. I have the below:

=COUNT([Column]:[Column], "No")

But if I try posting =COUNT([Column]:[Column], "Yes") below it, I get a BLOCKED error.

Anyone know how to solve?

Thank you!

Devin Lee

Are you using COUNTIF?

=COUNTIF(Column:Column, "Yes")

=COUNTIF(Column:Column, "No")

SNickNBCUniUSH

@Devin Lee Even when using COUNTIF, if I try putting both formulas in the column it gives me a BLOCKED error.

Devin Lee

@SNickNBCUniUSH What do you mean try putting both formulas in the column? Are they in the same column as the Yes and No column or in a separate one? You want them in a separate one or if they are in the same one make sure you are not including the Counts in the range you are looking for the Yes and No's in.

SNickNBCUniUSH

@Devin Lee I figured out how to get what I wanted (% of "Yes" for all rows in a column):

=COUNTIF([Column]:[Column], "Yes") / SUM([Column]:[Column])