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.)