Please help
 

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

One way

=SUMPRODUCT(--(A1:A1008000),--(A1:A100<12000),B1:B100)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



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