Newbie: Countif (Range) is between two numbers AND has status of 'Complete'
Hi, I've tried this but it's #UNPARSEABLE.
Any help gratefully received Thanks.
=COUNTIFS({CLOSED/ COMPLETED from June 2023 Range 1}, >=[Column4]@row, {CLOSED/ COMPLETED from June 2023 Range 1}, <=[Column5]@row) AND({CLOSED/ COMPLETED from June 2023 Range 3}, HAS("Completed")
I got a number (13) when I didn't have the AND feature, but I do need to also include the status as the Cancelled jobs are better performing than the Completed jobs (which are harder and take longer!)
Thanks
nualamcd
Answers
-
COUNTIFS automatically assumes everything is "and", so you don't need to try to work that in (generally speaking). There is also a syntax issue with the HAS function which really shouldn't be needed if you are not using a multi-select dropdown type column for the Status.
=COUNTIFS({CLOSED/ COMPLETED from June 2023 Range 1}, >=[Column4]@row, {CLOSED/ COMPLETED from June 2023 Range 1}, <=[Column5]@row, {CLOSED/ COMPLETED from June 2023 Range 3}, @cell = "Completed")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!