Hello @Christopher Neal

It looks like you would be looking for something like this:

=COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], >=[Start Date]@row,[End Date]:[End Date],<=[End Date]@row)

This would return the number of records for the Staff Team of that row; that have a Start Date >= the Start Date of that row, and an End Date >= the End Date of that row.

Hope this helps!

Let me know if I have misunderstood your question!

Cheers~

Krissia