Ask Your Question
0

what is wrong with this sumifs statement

asked 2018-09-25 10:09:16 +0100

krappleby gravatar image

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

Lupp gravatar image

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

edit retag flag offensive close merge delete

Comments

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

ebot gravatar imageebot ( 2018-09-25 14:57:58 +0100 )edit

1 Answer

Sort by » oldest newest most voted
2

answered 2018-09-25 16:36:25 +0100

JohnSUN gravatar image

updated 2018-09-26 06:19:39 +0100

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)
edit flag offensive delete link more

Comments

Everybody please aslo consider https://ask.libreoffice.org/en/questi... .

Lupp gravatar imageLupp ( 2018-09-25 23:19:54 +0100 )edit

Yes! You're right! Again. :-) Fixed

JohnSUN gravatar imageJohnSUN ( 2018-09-26 07:45:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-25 10:09:16 +0100

Seen: 71 times

Last updated: Sep 26 '18