Hi Guys,

Im trying to create a formula but im having problems,

In column A i have a list of about 5/6 names but they are repeated so i actually have about 30 rows. In column B, depending on ther criteria it will either say "Overdue", "Not Due", "Due Today" ect

What i want to do is have the list of these 5/6 names on another sheet and one column next to it saying the number of "overdue" items there are for that person?


Is this possible?

Thanks