Trying to Count, by State, if multiple criteria is met. I think I am close....but don't have something in the right place! Any help is appreciated!
=COUNTIFS(AND({State}, "FL", ({Activity}, OR(@cell = "ASA", @cell = "ASA (Multiple Systems)"))))
Hi @Smarty ,
You can do this as a sum of the 2 conditions:
=COUNTIFS({State},"FL", {Activity},"ASA")+COUNTIFS({State},"FL", {Activity},"ASA (Multiple Systems")
Or combine them into a single statement:
=COUNTIFS({State}, "FL", {Activity}, OR(@cell = "ASA", @cell = "ASA (Multiple Systems)"))
Hope this helps!
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.
