=SUMPRODUCT(--(A1:A10010),--(A1:A100<20),B1:B1:B100)

--
HTH

Bob Phillips

"jiwolf" wrote in message
...
I am looking to sumif the value in a cell is between 1 and 10. I am ok
with values above 10,

=SUMIF(A1:A100,"10",B1:B100) but I cant get above a certain value and
below another! any help please?


Pete