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

mark.gipson27746

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.

 

 

 

 

Chris McKay

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

mark.gipson27746

Awesome, Thanks Chris You Da Man!

Chris McKay

My pleasure