Try...

=COUNT(1/FREQUENCY(IF(LEFT(N1:N3000,2)="SE",IF(A1:A3000<"" ,A1:A3000)),IF
(LEFT(N1:N3000,2)="SE",IF(A1:A3000<"",A1:A3000))) )

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
ajajmannen
wrote:

Hi!!

i'm currently trying to count the number of unique numbers in a Column
using this formula:
=SUMPRODUCT((A3:A3002<"")/COUNTIF(A3:A4002;A3:A3002&""))
So far so good.....But I want to add some conditions like only count
the numbers that meet the condition say N1:N3000="SE*"

I tried a couple of things but nothing seem to work can you please help
out.....Don't laugh and I will paste my own failed solutions:
=SUMPRODUCT((A1:A3000<"");(AND(OR(N1:N3000="SE*"; N1:N3000="INC*")/COUNTIF(A1:
A3000;A1:A3000&""))))
On this one I get #VALUE! and i can't figure out why.
I have also tried to put the AND/OR condition before the actual
starting of the array of the SUMPRODUCT but nothing.