Nested criteria

Deb White

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.

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

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

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