Counting physical inventory while removing duplication...
I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is, some of these Unit Numbers have multiple work orders which are listed on another column, and a total work order count does not represent how full our facility truly is.
I was thinking of using:
=COUNTIFS(DISTINCT([Unit #]:[Unit #]... but how do I complete a DISTINCT count formula while only considering those On-Site "Green" indicated cells???