How to count the number of people aged 35 to 40 using excel?

For exampleHow to use excel to count the number of people aged 35 to 40?

Method:

1. Open excel to set age data, as shown in the figure

2. Set the age group partition, as shown in the figure

3. Select the cell under the age group partition, and click the formula function on the toolbar, such as Figure

4. Click the Insert Function function under the formula to pop up the Insert Function window, as shown in Figure

5. Select the statistical function, switch the window function, as shown in the figure

6. Click OK to switch the window display parameter function, select the area and set conditions, as shown in the figure

7. Click OK, and Excel will automatically calculate the number of people, as shown in the figure

8. The same calculation is done later, but you have to subtract Go to the maximum number of people in the previous segment

9. The last one is a little different and needs to be changed. Because there is no upper limit, the set condition is greater than the lower limit. , as shown in the figure

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to count the number of people aged 35 to 40 using excel?. For more information, please follow other related articles on the PHP Chinese website!