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

1. 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  Register To Reply

2. Re: Calculating how many outliers in a sheet based on name occurrence and overdue date

Maybe use COUNTIFS?

Formula:    Register To Reply

3. Re: Calculating how many outliers in a sheet based on name occurrence and overdue date

This worked for me, thanks very much!  Register To Reply

4. Re: Calculating how many outliers in a sheet based on name occurrence and overdue date

You're welcome.   Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 