Count by date and person

Alex Brock

I have successfully used the formula below to return a count of submitted issues on a log that have been resolved within the past week. I need to now take this amount and record the count by staff member who resolved the issue. On the source sheet I have a column where the individual is listed "First name Last name".

=COUNTIFS({Resolved Date Range}, IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(TODAY()), {Resolved Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

Paul Newcome

You would add another range/criteria set following the same syntax you have in your existing formula (range, criteria, range, criteria). The range would be the column with the name in it, and the criteria would be the name.