Mar 29 2021 12:41 PM
I need distinct counts from 1 worksheet onto another where the criteria is by date and the other is by a name. Below is what I was hoping would work but it does not. Can anyone help?
=COUNTIFS((SUM(IF(FREQUENCY('Suite C'!E:E,'Suite C'!E:E)>0,1)),'Suite C'!C:C,A7,'Suite C'!D:D,I1))
The worksheet I'm trying to pull info from:
Putting info into this worksheet:
Mar 29 2021 01:58 PM
Mar 29 2021 02:03 PM