Count unique values in a range from a worksheet with more than 1 criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-2243029%22%20slang%3D%22en-US%22%3ECount%20unique%20values%20in%20a%20range%20from%20a%20worksheet%20with%20more%20than%201%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2243029%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20distinct%20counts%20from%201%20worksheet%20onto%20another%20where%20the%20criteria%20is%20by%20date%20and%20the%20other%20is%20by%20a%20name.%26nbsp%3B%20Below%20is%20what%20I%20was%20hoping%20would%20work%20but%20it%20does%20not.%26nbsp%3B%20Can%20anyone%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTIFS((SUM(IF(FREQUENCY('Suite%20C'!E%3AE%2C'Suite%20C'!E%3AE)%26gt%3B0%2C1))%2C'Suite%20C'!C%3AC%2CA7%2C'Suite%20C'!D%3AD%2CI1))%3C%2FP%3E%3CP%3EThe%20worksheet%20I'm%20trying%20to%20pull%20info%20from%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Cindy_Heathman_0-1617046702449.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268007i18EF407DF03F6084%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Cindy_Heathman_0-1617046702449.png%22%20alt%3D%22Cindy_Heathman_0-1617046702449.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPutting%20info%20into%20this%20worksheet%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Cindy_Heathman_1-1617046829754.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268008i625551CD233296D1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Cindy_Heathman_1-1617046829754.png%22%20alt%3D%22Cindy_Heathman_1-1617046829754.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2243029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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:

Cindy_Heathman_0-1617046702449.png

Putting info into this worksheet:

Cindy_Heathman_1-1617046829754.png

 

 

 

 

2 Replies
Do you happen to have a sample you can upload? This might be do-able with a pivot table and distinct count OR with UNIQUE (and a few more functions), if you're on 365.
I'm wanting to try to stay away from a pivot table since this will be an on-going report, there will be a worksheet per employee. Trying to keep track of work done. Only examples that I have are what is in the discussion, worksheets that I'm trying to pull the information from.