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
|