Need help with Count If Frequency

**debralee** · 05-23-2018, 03:56 PM

I am looking for the total unique values in column D IF column F is 1
I have tried an array of sum, sum if and the below, all returning a #Value.

Both column D and F are all numeric values

Please help
Thank you

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

**FlameRetired** · 05-23-2018, 05:36 PM

Double posted here:
https://www.excelforum.com/excel-gen...frequency.html

**FDibbins** · 05-23-2018, 06:04 PM

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.

https://www.excelforum.com/excel-gen...frequency.html