Sum depending on the value

[HeriKuri]

Hi, how can I make a calculation depending on the value? I attached an example file, there are piles between 0-36 meters, I need SUM of 0-18 meters and 18-36 meters seperately, any way to do this?

[KOKOSEK]

	F	G	H	I
5	Production	0-18	18-36	Total
6		63	368	431.00

	F	G	H	I
5	Production	0-18	18-36	Total
6		=SUMIFS($D$4:$D$20,$B$4:$B$20,">="&LEFT(G5,FIND("-",G5)-1),$B$4:$B$20,"<="&MID(G5,FIND("-",G5)+1,10))	=SUMIFS($D$4:$D$20,$B$4:$B$20,">="&LEFT(H5,FIND("-",H5)-1),$B$4:$B$20,"<="&MID(H5,FIND("-",H5)+1,10))	=D21

You have to decide that it is should be <= / >= or sharp </> as 18 is on both ranges.

[HeriKuri]

Thank you, that's the solution.

[HeriKuri]

Hi, I think my messages are not being delivered, I don't see anything at my Sent Items, I asked you something I didn't understand about the formula.

[KOKOSEK]

I've got msg on PM.
EDIT: replied.