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