Average versus average based on filter

I need to use the result of a visual matrix to calculate a new column.   The data below is a simplified version of the data I have.     Table A Fuel Type Gallons Gross Cost Diesel Regular ...