=SUMPRODUCT(--(A4:A205000),--(A4:A20<7000),B4:B20)

--
HTH

Bob Phillips

"Mark" wrote in message
...
I have a simple spreadsheet with numerical codes in column A. in column B
i
have figures against each code. What i would like to do is use the sumif
function or any other function that would total the figures within a range
of
codes. For example if the code is greater than 5000 but less than 7000
total
the figures in colum B for those codes.

The formula i have tried with no luck is

=SUMIF(A4:A20,"5000"&"<7000",B4:B20)

It seems to be the 2 conditions that are causing the problem, it works
fine
with one condition but not with two.

Please advise

Thanx
Mark