Count Multiple Criteria
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
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?
Richard E. Lucas