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!
Are you using COUNTIF?
=COUNTIF(Column:Column, "Yes")
=COUNTIF(Column:Column, "No")
@Devin Lee Even when using COUNTIF, if I try putting both formulas in the column it gives me a BLOCKED error.
@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.
@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])
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
