I am trying to sum a range, column "C" on the condition that the value
in column "B" = 3000 and <4000. The formula I am using is
=SUMPRODUCT((A1:A93000)8(A1:A9<4000 ),(C1:C9)). When some playing
around I either get the sum of the entire column or 0. Neither answer
is correct. Appreciate your help.