COUNTIF Question
Hello,
I have a master list where I log all support requests with a summary of the request, due dates, ECD health ect. On my master list sheet, there is a dropdown column where I label the task health as either "in progress", "overdue", or "resolved." On a separate metric sheet, I am trying to use the COUNTIF formula that will count the number of tasks labeled with respect to the categories stated in the previous sentence. The formula is giving me issues pulling in the correct category - I'm not sure if this is because the "Task Health" column has 3 separate values, or if there is an easier way to achieve this.
The formula I've been trying:
=COUNTIF({OrthoFi RAIL - Masterlist Range 5}, {OrthoFi RAIL - Masterlist Range 15})
Answers
-
@Gabriellenkv You can't have your Criteria be a range. So you will need to create 3 separate summaries.
=COUNTIF(RANGE, "Over Due")
=COUNTIF(RANGE, "In Progress")
=COUNTIF(RANGE, "Resolved")
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!