CountIfs X does not contain...

I am trying to get a formula to function and am having trouble.

=COUNTIFS({KBeaver Workload Range 1}, "Complete", {KBeaver Workload Range 3}, "1", {KBeaver Workload Range 4}, NOT(CONTAINS("E:", @cell)), {KBeaver Workload Range 4}, NOT(CONTAINS("M:", @cell)))

This is attempting to count tasks completed in Q1 by looking for the "Complete" status, then looking for a "1" in quarter, then filtering out non-tasks (does not contain "E:" and does not contain "M:").

However, the formula above only gets me "Incorrect Argument Set".

Help?

Find more posts tagged with

Accepted answers

Paul Newcome

Everything else that could be causing that particular error looks fine. Lets try something a little different.

=COUNTIFS({KBeaver Workload Range 1}, "Complete", {KBeaver Workload Range 3}, "1", {KBeaver Workload Range 4}, FIND("E:", @cell) <> 1, {KBeaver Workload Range 4}, FIND("M:", @cell) <> 1)

All comments

Paul Newcome

Start by double checking your ranges to ensure they are all the same size and shape. If they are supposed to be covering an entire column, be sure that you are clicking on the column header to select the range.

Kaylynn Beaver

Yep! All ranges are full column references and selected correctly.

Paul Newcome

Everything else that could be causing that particular error looks fine. Lets try something a little different.

=COUNTIFS({KBeaver Workload Range 1}, "Complete", {KBeaver Workload Range 3}, "1", {KBeaver Workload Range 4}, FIND("E:", @cell) <> 1, {KBeaver Workload Range 4}, FIND("M:", @cell) <> 1)

Kaylynn Beaver

Thank you so much! That seems to have worked.

Though, I went back and refreshed my page as well. My first one worked too (though I have no idea why a refresh "fixed" it) 🤷‍♀️

Paul Newcome

Sometimes things can get a little buggy and a refresh is all you need. Glad it is working for you now.

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