Tom’s Tutorial For Excel: The FREQUENCY function
FREQUENCY function counts how often values occur within a range of values, and returns a vertical array of numbers. For example, the list in column A shows 14 test scores. The table in range C1:E6 summarizes the scores with the
FREQUENCY function in range E2:E6, to show how many test scores fall within numeric grading ranges.
FREQUENCY function in E2:E6 is
=FREQUENCY($A$2:$A$15,$D$2:$D$6). Here are 3 steps to enter this function:
An unusual and necessary first step is to select the range where the
FREQUENCY function will go. In the example, range E2:E6 is selected.
FREQUENCY function formula, which will mean you are typing it into the selection’s active cell, in this example being cell E2.
Press Ctrl+Shift+Enter to commit the formula to the selected range which you must do because
FREQUENCY is an array function. The curly braces you see in the formula bar in the following picture are NOT entered by you (notice they are not in the formula bar in Step 2). Excel enters those curly braces for you automatically when you press Ctrl+Shift+Enter for array formulas.