=SUMPRODUCT(--(A1:A1002000),--(A1:A100<10000),B1:B100)

It will not work if you use a whole column ex: A:A or B:B


"gottahavit" wrote:

I am trying to use multiple criteria for SUMIF. Let's say I have a bunch of
numbers in colum A. I am trying to identify the ones that are between 2000
and 10000, multiply those numbers with the corresponding numbers in column B,
and then add those numbers up.
I hope that makes sense. I just can't get it to work.
Thanks.