In this example, we'll use SUMPRODUCT to return the total sales for a given item and size: SUMPRODUCT matches all instances of Item Y/Size M and sums them, so for this example …