Nested Crtiteria

Karrie Davis

Hi, 

 

I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria. 

=COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary Column]8, {Owner}, @cell = "Erica"))

 

Paul Newcome

You would want to close out your first COUNTIFS then add the second.

 

=COUNTIFS(.....)

+

COUNTIFS(......)

.

However, you can use OR and AND functions within a COUNTIFS to include multiple or differing sets of criteria for a single range.

 

Something like this might work for you...

 

=COUNTIFS({Status}, AND(@cell <> $[Primary Column]7, @cell <> $[Primary Column]8), {Owner}, @cell = "Erica")

Karrie Davis

Thank you,

 

That worked

Paul Newcome

Happy to help!