Sumproduct problem
 

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?

Sumproduct problem
 

Sounds like either column A and/or N2 may be formatted as TEXT.

Try this:

Select an empty cell.
Copy that empty cell
Select your range in column A and/or N2
Then do: EditPaste specialAddOK

Biff

wrote in message
ps.com...
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?