Nested criteria

I have this formula but it comes back with a "nested criteria" error message:

COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV") + COUNTIFS([Business Unit]:[Business Unit], OR(@cell = "PRC", @cell = "IFG"), Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV")))

I want to be able to find out how many units come back (stage 3 & 4) that are from business unit MGS in Orange County + how many units come back (stage 3 & 4) from business unit PRC and IFG.

I think I'm close but need a tweak please.

Find more posts tagged with

Accepted answers

Mark Cronk

Hi @Deb White ,

Try:

=COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV") ) + COUNTIFS([Business Unit]:[Business Unit], OR(@cell = "PRC", @cell = "IFG"), Stage:Stage, OR(@cell = "3 - Approved", @cell = "4 - LOI/IOV"))

You had 1 paren out of place.

Work?

Mark

All comments

Mark Cronk

Hi @Deb White ,

Try:

You had 1 paren out of place.

Work?

Mark

Deb White

I was soooo close :) Thank you!

Mark Cronk

1 paren is all that was in your way. Bet it doesn't happen again. Happy to help. Thank you for contributing to the Community.

Mark

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.