Microsoft Excel Functions & Formulas

Use the FREQUENCY function to calculate the

number of sold products for each group

The table in Figure 11-25 lists the number of products sold daily. To

do some market analysis and check consumer behavior, group the

list and count the different consumption patterns. Use the

FREQUENCY function entered as an array formula to count the

frequency by different groups.

4

To calculate frequency and check purchasing habits:

1. In column A, enter dates in ascending order.

2. In column B, list the number of products sold daily.

3. Define the different groups in cells D2:D5.

4. Select cells E2:E6 and type the following array formula:

=FREQUENCY(B2:B11,$D$2:$D$11)