bilal_aoun
New Member
- Joined
- May 3, 2021
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
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
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