COUNTIF Question

Gabriellenkv

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})

Eric Law

@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")