One way

=SUMPRODUCT(--(A1:A10010000),--(A1:A10000<12000),B1:B10000)


Regards,

Peo sjoblom


boogie wrote:
Hi there
I am trying to create a formula that refences < numbers in a columm then
adds up the from a different columm
i.e add b1:b100 only if a1:a100 is 10000 <12000 =46
a b
10000 32
9000 64
12001 86
11999 14
9990 12