Please help Count if Frequency

My first thought is to change the F column range to match the number of rows that FREQUENCY returns. If you are not aware of it FREQUENCY returns one more bin (row) than the input.

=SUMPRODUCT(--(FREQUENCY(SURVEYS!D4:D11075,SURVEYS!D4:D11075)>0),--(F4:F11076>=1),--(F4:F11076<1))

Edit Additionally as an alternative to FREQUENCY for returning unique values you might try nesting this.

You'll need to array enter the formula now. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

=(MATCH(SURVEYS!D4:D11075,SURVEYS!D4:D11075,0)=ROW(D4:D11075)-MIN(ROW(D4:D11075))+1)

The formula now:
=SUMPRODUCT(--ISNUMBER(--(MATCH(SURVEYS!D4:D11075,SURVEYS!D4:D11075,0)=ROW(D4:D11075)-MIN(ROW(D4:D11075))+1)),--(F4:F11075>=1),--(F4:F11075<1))

If this is not satisfactory try uploading a small sample Excel file representative of what you are working with and what you hope to achieve.

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.