As per lookup criteria return a values of total consumption of liters per machinery.

Please try at
E13
=SUM(INDEX(C2:N7,MATCH(E10,A2:A7,),MONTH(1&E11)):INDEX(C2:N7,MATCH(E10,A2:A7,),MONTH(1&E12)))

H12
=SUM(INDEX($C$2:$N$7,MATCH($H$10,$A$2:$A$7,),RIGHT(G12)*3-2):INDEX($C$2:$N$7,MATCH($H$10,$A$2:$A$7,),RIGHT(G12)*3))