ok, searched but couldn't find anything on my problem.

here is my formula:


=SUMPRODUCT(($A$1:$A$10000=$N2)*($E$1:$E$10000=Q$ 1)*($E$1:$E$10000<R$1),$F$1:$F$10000)

which work awesome, but the list in column A is serial numbers, which
can be integers or alfa-numeric. and for some reason it wont pick up
the integer values?

any ideas?