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
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?
Richard E. Lucas
Best Answer
-
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"))
Answers
-
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"))
-
That worked great! Thank you.
Richard E. Lucas
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives