Using multiple conditions from multiple columns for CountIF

darrink

Hi, I'm trying to use conditional logic to count how many rows meet the following conditions. But I seem to missing something...

=COUNTIF(([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved")), +([Promo]:[Promo], OR(@cell = "Value 1", @cell ="Value 2", @cell = "Value 3")))

I've also tried this:

=COUNTIF(([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved")), AND([Promo]:[Promo], OR(@cell = "Value 1", @cell ="Value 2", @cell = "Value 3")))

I also tried

=COUNTIFS(([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved")), +([Promo]:[Promo], OR(@cell = "Value 1", @cell ="Value 2", @cell = "Value 3")))

=COUNTIFS(([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved")), AND([Promo]:[Promo], OR(@cell = "Value 1", @cell ="Value 2", @cell = "Value 3")))

Paul Newcome

Based on your updated post with the COUNTIFS, your second COUNTIFS would be the closest but you have too many parenthesis tucked in and you do not need the AND statement. Try just following the syntax outlined in the article. There are a few examples underneath the "Usage Notes" section that show the proper syntax.

Paul Newcome

You need a COUNTIFS (with the "S" on the end) to include multiple range/criteria sets.

https://help.smartsheet.com/function/countifs

darrink

Thanks Paul, I tried that and it also didn't work. I think there must be a syntax issue...

Paul Newcome

Based on your updated post with the COUNTIFS, your second COUNTIFS would be the closest but you have too many parenthesis tucked in and you do not need the AND statement. Try just following the syntax outlined in the article. There are a few examples underneath the "Usage Notes" section that show the proper syntax.

darrink

Thanks Paul, here is the updated syntax and it works! Thank you!

=COUNTIFS([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved"), [Promo]:[Promo], OR(@cell = "Value 1", @cell = "Value 1", @cell = "Value 1"))

Paul Newcome

Happy to help. 👍️