Sales for multiple products in 1 Cell

[bilal_aoun]

Would you please help me find the sale in a single cell?
Sales per day in cells B2:H9
Product type A5:A9
Product Price
B16:C21

If we are to transpose the date in cells E17:E24, can we find the total sales in dollar in F18:F24?

 

[jasonb75]

The formula should work as suggested, even if the order is changed or the range is extended.

If you note my comment,

you could do it without the transposed criteria but it would be at the risk or incorrect results

I meant that the formula could be shortened with the current layout, but not with changes.