I just noticed the second part of the question. To count the number of
unique numbers in Column A where the corresponding value in Column N is
either SE or INC, try...

=COUNT(1/FREQUENCY(IF(ISNUMBER(MATCH(N1:N3000,{"SE","INC"}, 0)),IF(A1:A300
0<"",A1:A3000)),IF(ISNUMBER(MATCH(N1:N3000,{"SE", "INC"},0)),IF(A1:A3000<
"",A1:A3000))))

....confirmed with CONTROL+SHIFT+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.