Sumproduct problem

[collis47]

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?

 

[T. Valko]

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: Edit>Paste special>Add>OK

Biff