Calculating how many outliers in a sheet based on name occurrence and overdue date

I have a spreadsheet which calculates the dates when a project starts and ends, with the name of the person completing the project

Columns - A: Job title, B: Name, C:Start date, D: Due date, E: Date of actual completion, F: Days overdue

The point is to find out which people finish which projects late and how often this occurs. The problem is that the names often occur multiple times in the sheet, not in order, and new names are always being added to the sheet.

Is there any way I can include a formula in column H which calculates how often someone completed a project late?

E.g:
Late projects
H
(Name) 4
(Name) 0
(Name) 7

Thank you for your help in advance

Maybe use COUNTIFS?

Formula:

Please Login or Register  to view this content.

You're welcome.