For a simplification, I have the following:

CID=[32,33,34,35,36,37,38,39]

DATA:

A B C
21 .30 34000
21 .50 40000
32 .99 34000
32 .01 36000
33 .03 34000
33 .50 47010
42 .60 34000
42 .40 70100

I need to set up a formula to sum up the total in column "B" for all cases
where the value in column "A" is equal to any of the values in CID and the
value in column "C" is greater than 30000 and less than 40000. (Here, then
the answer would be 1.03)