# 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

Thank you for your help in advance

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

Maybe use COUNTIFS?

Formula:
`Please Login or Register  to view this content.`

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

This worked for me, thanks very much!

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

You're welcome.

##### Users Browsing this Thread

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1