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

E13

=SUMPRODUCT(($A$2:$A$7=E10)*(DATEVALUE(1&$C$1:$N$1)>=DATEVALUE(1&E11))*
(DATEVALUE(1&$C$1:$N$1)<=DATEVALUE(1&E12))*$C$2:$N$7)

H12

=SUMPRODUCT(($A$2:$A$7=$H$10)*(DATEVALUE(1&$C$1:$N$1)<=DATE(2020,
ROW(1:1)*3,1))*$C$2:$N$7)-SUM($H$11:H11)

Drag down