You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"PCLIVE" wrote in message
...
This works the way I need. Thanks for the tip on the extensive ranges. I
did that quickly just as an example.

Thanks again,
Paul

--

"T. Valko" wrote in message
...
=SUM(IF(FREQUENCY(IF(C:C=A5,D:D),D:D),1))

I assume you're using Excel 2007.

Try it like this:

=SUM(IF(FREQUENCY(IF((C:C=A5)*(E:E=5)*(F:F=4),D:D) ,D:D),1))

I'd use a smaller specific range if I were you! You're testing well over
3 million cells!

--
Biff
Microsoft Excel MVP


"PCLIVE" wrote in message
...
I'd like to apply some additional criteria to this unique value count.

=SUM(IF(FREQUENCY(IF(C:C=A5,D:D),D:D),1))

The array formula works ok without additional criteria. However, I'd
also like to include the rows where cells in E:E equal 5 and F:F equal
4. I've done a SUMPRODUCT that would determine that without determining
the unique values, but I want to somehow combine the two.

Any ideas.
Paul