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

Hi,

Required a formula help as based on data set in Cells A7 to N7, to return a total values of consumption of liters per machinery, as per look up period months and quarters, and for the same automatically highlight the result cells to know the about the values originates from which cells with conditional formatting.

Sample sheet with expected results are attached.


Thanks,