I would like to sum all the costs based on the products purchased between specific dates.
=SUM(ARRAYFORMULA(IFERROR(VLOOKUP('Purchased List Table'!B2:B,'Pricing Table'!A2:B,2,0),"")))
With the formula above, I managed to sum all the prices of all products in the Purchased List Table instead of a certain timeframe.
How could I modify the formula in order to sum only the costs of products within specific timeframe (e.g.: between 9/3/2021 to 9/5/2021 only)?