Count of requests with team member with specific request statuses

Shikha Kapoor 3

sharing below sample data wherein one column I have list of team members and other columns I have status of the requests . Can someone help with formula to find the count of all the requests with Alice having status either In progress and Delayed. I dont want to count Cancelled count.

Resource Request Status

Alice In progress

Alice In progress

joe Cancelled

Tom In progress

Alice Cancelled

Alice Delayed

Alice Delayed

Nick Korna

Hi @Shikha Kapoor 3,

You have a few options.

Counting those 2 specific choices (In Progress or Delayed):

=COUNTIFS(Resource:Resource, "Alice", [Request Status]:[Request Status], OR(@cell = "In Progress", @cell = "Delayed"))

Counting everything that isn't cancelled:

=COUNTIFS(Resource:Resource, "Alice", [Request Status]:[Request Status], <>"Cancelled")

Or as an alternative if you need the details just at a glance, you could also use a report.

Hope this helps, but if you've any problems/questions then just let us know!