COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion.
So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO")))
As per my database, I have 80 entries for Cupertino, but counting the days I've worked there for 22 days, and with the formula gives 1 as the value:
Then, I tried counting the days instead of sites:
=COUNT(DISTINCT(COLLECT([Site ID]:[Site ID], Date:Date, "01/01/23")))
How can I count the days I've spent on a job site?
Help Article Resources
Check out the Formula Handbook template!