Count # of issues with the same Assigned Date

A.Vo

I have an issues tracker with Status drop down column and an Assigned Date column noting the date the issue was assigned to someone. I want to count the total issues by Assigned date that are in specific status, i.e.: Open, Client, Retest, etc. Looking for something that says

Status = Design Change

Date= 10/5/22

Count = 10

Brucey

Hiya @A.Vo

Try something like this:

I imagine you'll use a summary row at the bottom or something but the formula will work

=COUNTIFS(Status:Status, "Design change", Date:Date, DATE(2022, 10, 5))

And then you can change around the values depending on what you are looking for (different date or status).

A.Vo

Brucey, thank you for the suggestion. This is looks like I'm identifying a specific date. However, this column will have a 2 months worth of different dates. Does this require me to create a separate count for every assigned to Date?