What makes the SUMPRODUCT function even more powerful is its ability to nest formulas, or in simple terms, add another function within the SUMPRODUCT function.
Instead of getting the Total Sales for a region, we can extract the Maximum sales value simply by entering the MAX function before the criteria. See how below.
