Multiple Countifs Using Symbols

I am not an advanced formula user. I want to find the count of records that have multiple criteria. The formula I'm using now returns a value of 3, but should be 9.

=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, <>"Low")

I have a symbol column in my Action Item page that uses the 3 priorities (High, Medium, Low). Of the 9 records, three priorities are "Medium" and the remaining 6 are blank "". I want the formula to return null (""), "Medium", and "High" counts summed together (9). Basically, I want to exclude records with "Low" priority, but using my formula it returns a value of 3, seemingly disregarding blank priority values.

Thanks in advance for any assistance you can provide in cleaning up my formula.

Find more posts tagged with

Formulas

Accepted answers

All comments

L_123

=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), OR(@cell <> "Low", @cell = ""

SS_user10294507

L_123, thank you for your response. I receive a "#INVALID OPERATION" error when using this formula. Do I need to use the {AI Priority} reference instead of @cell? I tried to replace @cell with {AI Priority}, but doesn't seem to work.

L_123

Yeah sorry, I cut out the reference....

=COUNTIFS({Action Item Status}, "Canceled", {Action Item Due Date}, <DATE(2022, 12, 1), {AI Priority}, OR(@cell <> "Low", @cell = ""

SS_user10294507

L_123, This works great. Thank you kindly!!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.