COUNTIFS function with multiple criteria
I have what I think should be a simple formula, but I only get "#UNPARSEABLE".
I just want to return a count when the WAVE column contains "Wave 2" AND the STATUS column contains "Not Started". My current formula is:
=COUNTIFS({Wave}, "Wave2" AND {Status}, "Not Started")
Best Answer
-
Try
=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")
The
COUNTIFS
function allows you to specify multiple pairs of ranges and criteria. Each pair represents one condition. The function counts only those cells where all specified conditions are met simultaneously.if you still get errors it could be how you have {Wave} and {Status} defined
=COUNTIFS([Wave]:[Wave], "Wave2", [Status]:[Status], "Not Started")
Answers
-
Try
=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")
The
COUNTIFS
function allows you to specify multiple pairs of ranges and criteria. Each pair represents one condition. The function counts only those cells where all specified conditions are met simultaneously.if you still get errors it could be how you have {Wave} and {Status} defined
=COUNTIFS([Wave]:[Wave], "Wave2", [Status]:[Status], "Not Started") -
Thank you - changing to the following fixed it
=COUNTIFS({Wave}, "Wave2", {Status}, "Not Started")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!