Using multiple conditions from multiple columns for CountIF

Options
darrink
darrink ✭✭✭
edited 11/13/23 in Formulas and Functions

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")))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!