Welcome!

count how many times a "Department Name" comes up with completed date

I want to count how many times a "Department Name" shows up once a complete date has been entered into the date "Completed Date" column.

Formulas

Hi Mark,

This will do what you're after:

=COUNT(COLLECT([Completed Date]:[Completed Date], [Department Name]:[Department Name], "Department Name"))

Kind regards,

Chris McKay

Awesome, Thanks Chris You Da Man!

My pleasure

Display N/A if Join/collect formula finds no result
This discussion was created from comments split from: Index Match with multiple results?.
Weighted Average in Project Plans
I'm assuming that the project plan template uses a weighted average to determine % complete on the various sections of the project as well as the project overall. Does anyone know what formula is actually being used?
Clock In and Out with Lunch Time Stamps
I need help creating a formula that will calculate my employees time in and out along with their lunch break.