CountIfs

Is there a limitation to Count if formulas?

COUNTIFS({Active Sites Range 2}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Active Sites Range 52}, "Site Visit REA"))

I would like to add a 3rd Range and 3rd Criteria to this formula but seem to be having and issue doing that. Is there a limit?

Thank you

John

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

There are a few limits, but I believe your issue may be that you need to remove one of the closing parenthesis from the end of the formula.

MCSCOO

Paul,

Here is the full formula I am trying to use

=(COUNTIFS({Active Sites Range 2}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Active Sites Range 52}, "Site Visit REA"{Active Sites Range 50},"Not Started")

Its not working

Paul Newcome

Now you have an extra opening parenthesis at the beginning that needs removed, and you are missing the comma between the second criteria and third range.

MCSCOO

Thanks Still no Luck after I made these changes

=COUNTIFS({Active Sites Range 2}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Active Sites Range 52}, "Site Visit REA,"{Active Sites Range 50},"Not Started")

Paul Newcome

You have the comma after the second criteria inside of the quotes. Try putting the quotes before the comma.

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.