We want Gross profit = SUM(Volume*Price)

Total Gross Profit is calculated by SUMPRODUCT and from the normal multiplication of columns.

Also in column J we have Sore than can de defined by the user. Based on the specific store, Conditional SumProduct calculates the Gross Profit of that store.