Microsoft Excel Functions & Formulas

Use the SUM function to count values that

match several criteria

In the previous example, we took two criteria into consideration.

Now let’s adapt that example for three criteria. Count all rows that

meet these criteria: The material is “wood” (column A), the size is

larger than 500 (column B), and the sales price is higher than

$5,000 (column C). To get the desired result, use an array formula

that takes care of all three criteria.

4

To count special values that match several criteria:

1. In cells A2:A11 enter materials like wood, aluminium, and

metal.

2. In cells B2:B11 list sizes from 100 to 1000.

3. In cells C2:C11 enter the sales price for each product. ...