COUNTIF formula
I'm trying to add a formula to a metrics sheet to count the number of issues by both a project name name and status. Project name and Status are columns in the worksheet I'm referencing.
In this case the project is called DREAM and the primary column on my the metrics sheet lists the options resolved and unresolved
I tried this but it's giving me #incorrectargumentset
=COUNTIF({Study}, "DREAM", {Status}, [Primary Column]@row)
Any suggestions on how to write this properly?
Answers
-
You just need to change the function to a COUNTIFS (with the "S" on the end) so that you can include multiple range/criteria sets.
I only ever use COUNTIFS because it works with just one range/criteria set, and I don't have to worry about forgetting to update the main function in the event that I need to add to it. Same with SUMIFS instead of SUMIF.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!