It would still be 3, the first occurrence of def has a value in F


--
Regards,

Peo Sjoblom



"Joe Gieder" wrote in message
...
I don't understand how it could be 3 when I don't want it to count the def
because one of the values next to def in column F is blank. I have 3
different unique values in column P you are correct, abc, def and ghi.
Only
abc and ghi should be counted though since they all have a value in column
F.

Thanks you for your help.
Joe

"Teethless mama" wrote:

The answer should be 3 not 2

=SUM(IF(FREQUENCY(IF((A1:A8="001")*(F1:F8<""),MAT CH(P1:P8,P1:P8)),MATCH(P1:P8,P1:P8))0,1))

ctrl+shift+enter, not just enter


"Joe Gieder" wrote:

First thank you for looking at this post and helping to find a solution
What I'm tying to do is create a formula that will count how many
unique
values are in column P if column F is not blank and column A matches a
value
in another worksheet. I can't use the auto filter because the formula
will be
used within another formula (I hope).

A F P
001 1 abc
001 2 abc
001 5 abc
001 2 def
001 def
001 1 ghi
002 10 abc
003 20 abc
The result I'm looking for is 2 because I'm using 001 as the criteria
to
match and supplier def has a blank in column F even though there's a
value
with the other def.

TIA
Joe