Sumproduct

[Probyn]

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:A9>3000)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.

 

[Dave Peterson]

Your formula is looking at column A.

It's better to copy and paste directly from excel into the newsgroup post. If
you just type it into the newsgroup message, it's difficult to guess if it's a
real problem or just a typo in the post (like 8 instead of *).