I am creating a matrix and I need help on a formula
The formula I am trying to create would be:
=sumif(a1:a100) is greater than 8000 but less than 12000 then
add the figuresfrom b1:b100
eg.
a b
9000 125
7000 85
11995 325
answer would equal 450

thank you
Clinton