Count Multiple Criteria

Options

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?

Best Answer

Answers