Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

click to hide/show revision 2
None

updated 2018-09-25 23:12:59 +0200

Lupp gravatar image

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

click to hide/show revision 3
None

updated 2018-09-25 23:15:31 +0200

Lupp gravatar image

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

click to hide/show revision 4
None

updated 2018-09-25 23:16:01 +0200

Lupp gravatar image

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