Summary Count w/ Multiple Criteria
Help please! I am trying to use the sheet summary to count with two criteria - Test Status and Region. I want to see the number of test scenarios that are in the US and Not Started, as well as Europe/Not Started, India/Not Started, etc. I have tried several variations of what I thought would work and I'm still getting #UNPAREABLE.
=COUNTIFS(CHILDREN([Test Status]1:[Test Status]1292), "Not Started"), AND(CHILDREN([Region1:Region1292]), "US")
=COUNTIFS(CHILDREN([Test Status]1:[Test Status]1292), "Not Started"), (CHILDREN([Region1:Region1292]), "US")
=COUNTIFS(CHILDREN([Test Status]1:[Test Status]1292)), "Not Started", (CHILDREN([Region1:Region1292])), "US")
Answers
-
Why are you using Children?
-
Try =COUNTIFS([Test Status]1:[Test Status]1292, "Not Started", [Region1:Region1292], "US")
-
I have parent rows throughout which I am showing the status, but I don't want to count those rows. The formula you suggested did not work, still showing #UNPARSEABLE.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!