View Single Post
  #1   Report Post  
boogie
 
Posts: n/a
Default FORMULAS please help

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