Microsoft Excel Functions & Formulas

Use the DCOUNT function to count cells in a

range between x and y

Use the data in the previous example to continue working with the

DCOUNT function. Here we want to count all products of the vege-

table category that cost more than $1.75 but less than or equal to

$2.50.

4

To count cells in a specific range between x and y:

1. Copy range A1:E1.

2. Select cell A14 and paste the copied cells with <Ctrl+V>.

3. Select cell C15 and type vegetable.

4. In cell E15 type >1.75.

5. In cell F15 type <=2.50.

6. In cell C17 type the following formula:

=DCOUNT(A1:E11,E14,A14:F15).

7. Press <Enter>.

202

Chapter 8

Figure 8-3