=SUMIF(A:A,"=1000",B:B)-SUMIF(A:A,"2000",B:B)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gottahavit" wrote in message
...
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.