CountIFS with cross reference sheet with multiple drop down selections

Ari_Ari

Hi,

I am trying to get a count of status from cross reference sheet, with multiple dropdown selections in the same column. Here is what I tried and it's giving me wrong number or unparseable error.

=COUNTIFS({Communications Database Status}, "In Progress Compliance", {Communications Database Status}, "In Progress BO")

What am i doing wrong?

Thank you.

Leibel S

@Ari_Ari

Use the OR function:

=COUNTIFS({Communications Database Status}, OR(@cell="In Progress Compliance", @cell= "In Progress BO"))

Leibel S

@Ari_Ari

Use the OR function:

=COUNTIFS({Communications Database Status}, OR(@cell="In Progress Compliance", @cell= "In Progress BO"))

Ari_Ari

@Leibel S

Thank you. As logical as it sounds, I tried OR and at first it gave me unparseable error. At second try it worked. :)

First try - my formula

=COUNTIFS({Regulatory Communications Database|Status}, OR (@cell ="In Progress BO", @cell= "Awaiting BO Confirmation"))

Second try - my formula

=COUNTIFS({Regulatory Communications Database|Status}, OR(@cell ="In Progress BO", @Cell= "Awaiting BO Confirmation"))

Strange that SmartSheet would not forgive this syntax error?

Jon Crockett

I'm trying something similar but struggling.

I don't want a total if either criteria works (which gives me a big number - but rather a count only if both criteria are met.

I tried to replace OR with AND but it failed.

Thoughts?