what is wrong with this sumifs statement

[krappleby]

I have tried many different possibilities, but non seem to work

=SUMIFS($ADDITIONAL.H4:H8,E2,">=ADDITIONAL.F4:F8",E2,"<=$ADDITIONAL.G4:G8")

here is the jist.

i have two sheets, one contains a list of products, and im trying to get the cost of delivery off a second sheet based on the weight of the package…

$ADDITIONAL.H4:H8 = The column containing the price of delivery on the second sheet
E2 = the field on the first sheet with the weight of the item
$ADDITIONAL.F4:F8 = the column on the second sheet containing the minimum weight for that price
$ADDITIONAL.G4:G8 = the column on the second sheet containing the maximum weight for that price

for example, if the item weight is 1.45 kilo, then the result should be

sum up price where weight is more than minimum but less than maximum.

this should result in a price. but i keep getting errors, from 502 - 510

any help appreciated.

thanks

(Slightly edited ba @Lupp to get formulae / references as preformatted code.)

[Hrbrgr]

Can you anonymize the file and upload it here? Please edit your question.

[JohnSUN]

Just change the sequence of parameters - even the parameters should be ranges of the same size as the range of summation, and the odd ones should be the selection conditions.

=SUMIFS($ADDITIONAL.H4:H8; ADDITIONAL.F4:F8; "<=" & E2; $ADDITIONAL.G4:G8; ">=" & E2)

[Lupp]

Everybody please aslo consider Why do I often get an error (508, 504, 502 e.g.) if I paste a Calc formula from some post into my sheet? .

[JohnSUN]

Yes! You’re right! Again. Fixed