Count Multiple Criteria

Richard Lucas

I'm trying to count a number of different items with multiple criteria.

This is how I currently have it :

=SUM(COUNTIF(Department:Department, "03 AACA Finance") + (COUNTIF(Department:Department, "03 AANJ Finance

e")))

Is there an easier way since SS doesn't do arrays or do I need to keep adding the COUNTIF to the formula for each criteria?

L_123

Smartsheet can handle arrays, a couple examples of array formulas are collect() and distinct(). That said you don't need to handle arrays for this formula.

COUNTIF(Department:Department, or(@cell = "03 AACA Finance", @cell = "03 AANJ Finance"))

L_123

Smartsheet can handle arrays, a couple examples of array formulas are collect() and distinct(). That said you don't need to handle arrays for this formula.

COUNTIF(Department:Department, or(@cell = "03 AACA Finance", @cell = "03 AANJ Finance"))

Richard Lucas

That worked great! Thank you.