Microsoft Excel Functions & Formulas

Use the SUBTOTAL function to count rows

in filtered lists

When using the Filter option in the Data menu, it is recommended

that the COUNT and COUNTA functions not be used because in a

filtered worksheet they count both visible and hidden rows.

Instead, use the SUBTOTAL function to get the subtotal of a list or

database that is visible. The syntax for the SUBTOTAL function

was presented earlier in this chapter.

4

To count rows in a filtered list:

1. In cells B2:B10 type group numbers from 1 to 3.

2. In cells C2:C10 type the daily sales of each group.

3. From the Data menu, select Filter | AutoFilter.

4. Select group 1 in the column B filter.

5. Select cell ...