Microsoft Excel Functions & Formulas

Use the SUM function to count values that

match two criteria

To count values in a list, normally the COUNTIF function is used.

Unfortunately, COUNTIF cannot be used to count when several cri-

teria must be taken into consideration. However, it is possible to

get the desired result using an array formula. Use the SUM func-

tion to consider several criteria. In this example, we count the rows

that contain the word “wood” in column A and have a size larger

than 500 in column B.

4

To count special values that match two criteria:

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

metal.

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

3. In cells C2:C11 ...