Revision history [back]

what is wrong with this sumifs statement

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  2 None Lupp 12860 ●36 ●98 ●181 what is wrong with this sumifs statement 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 $ADDITIONAL.H4:H8 = The column containing the price of delivery on the second sheet E2 E2 = the field on the first sheet with the weight of the item$ADDITIONAL.F4:F8 $ADDITIONAL.F4:F8 = the column on the second sheet containing the minimum weight for that price$ADDITIONAL.G4:G8= $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  3 None Lupp 12860 ●36 ●98 ●181 what is wrong with this sumifs statement 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.

thanksthanks

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

 4 None Lupp 12860 ●36 ●98 ●181

what is wrong with this sumifs statement

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