Frequency is the most commonly used function for calculating the number of consecutive times. Next we will provide a detailed illustration of this function in the application of the number of consecutive times.
First, we need to understand the computing principles of frequency functions.
Freqency (Data region, used to set an array of interval separation points)
Purpose:
Simply put, there are several numbers in each set value range. (Frequency distribution)
For example, if column A has 35, 45, the values are 0 to 90 respectively ~ 60, 61 ~ There are several numbers in the three regions 80 and 80 respectively. The formula can be written in this way.
= Frequency (A1: A6, B1: B2)
Analysis:
Although we need to set three regions, we only need to set two numbers, namely 60 and 80, which represent 0 ~ 60, 61 ~ 80 and greater than 80. That is to say, the result returned by the function on frequency is greater than the number of the second parameter.
Note: As this is an Array Function, You must select the number of cells greater than the segment point during input. Enter the formula and press Ctrl + Shift + enter to end the input.
Excel frequency Function