» Performing calculations based on multiple criteria, using SUMPRODUCT function
Calculating the total sum of discounts made.
A discount is available when the value in the discount column (F) = ""YES"" and
only for prices higher than 2000.
To find the discount on the price in cell B7, according to the above criteria,
use the following formula:
|Screenshot // Performing calculations based on multiple criteria, using SUMPRODUCT function|