Summarize Issues Resolved Last Month by Assignee

GenoaA607

I want to summarize the # of tickets completed last month broken down by assignee. I know the formula to bring back the # of resolved tickets, but what formula would I use further break it down by assignee?

=COUNTIFS([Resolved Date]:[Resolved Date], IFERROR(MONTH(@cell), 0) = MONTH(TODAY([Issues Resolved Last Week]#)), [Resolved Date]:[Resolved Date], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

For example if Person 1 completed 2 tickets and Person 3 completed 5

Paul Newcome

You would add another range/criteria set the same way you have done the date range/criteria sets.

=COUNTIFS([Resolved Date]:[Resolved Date], IFERROR(MONTH(@cell), 0) = MONTH(TODAY([Issues Resolved Last Week]#)), [Resolved Date]:[Resolved Date], IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {range}, critera)