COUNTIFS with multiple criteria
I am trying to count the number of projects with a due date in the past and a Status of In Progress, In Review, or On Hold. This is what I have, but it returns unparseable.
=COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY (), [Status:Status, ="In Progress"], [Status:Status, ="In Review"], [Status:Status, ="On Hold"])
Can you help?
Thanks.
Best Answer
-
Looks like you have a few sets of brackets where they don't need to be, you have a space at the end of TODAY function that is causing problems, and you need an "OR" condition. Try this instead:
=COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY(), Status:Status, OR(@cell="In Progress", @cell= "In Review", @cell= "On Hold"))
Hope this helps!:)
Answers
-
Looks like you have a few sets of brackets where they don't need to be, you have a space at the end of TODAY function that is causing problems, and you need an "OR" condition. Try this instead:
=COUNTIFS([Requested Due Date]:[Requested Due Date], <=TODAY(), Status:Status, OR(@cell="In Progress", @cell= "In Review", @cell= "On Hold"))
Hope this helps!:)
-
Thanks! That worked!
-
Awesome! Glad to hear it:)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!