Forum Discussion
danielting1
Mar 24, 2021Copper Contributor
EXCEL: Sum of the multiplication between two tables with the criteria matched
I have this issue, where I need to multiply between two tables with the same header. For simplicity sake, let's just put 3 products - Product A, B, C. I have month-end data for both month-...
SergeiBaklan
Mar 24, 2021Diamond Contributor
If dates are in different order first you need return dates
e.g. as
=SORT(Qty[Date])
and at the right calculate price for each date
=SUM(XLOOKUP(G3,Qty[Date],Qty[[A]:[C]])*
XLOOKUP(G3,Price[Date],Price[[A]:[C]]))