Sales for multiple products in 1 Cell (to account for table order and #N/A)

[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?

=SUMPRODUCT(INDEX($B$5:$H$9,0,MATCH(E18,$B$4:$H$4,0))*($A$5:$A$9=TRANSPOSE($B$17:$B$21))*$C$17:$C$21)

Now I am trying to make this more dynamic (not impacted by NA or the order in B17:C21

 

[bilal_aoun]

If I change the order of product to match the A5:A9 it will work fine

 

[Fluff]

The data you posted in post#13 & #16 both contain a space after the word Apple in A5

 

[bilal_aoun]

Thought I Trimmed the Text

Thanks,

 

[Fluff]

Glad we could help & thanks for the feedback.