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