How to calculate the number of people separately in Excel: First open the table and enter the number of men and women in the column; then enter [:=COUNTIF(C1:C13, "Male")] in the cell after the number of boys; then enter the number of girls in the cell Enter [:=COUNTIF(C1:C13,"Female")] in the following cell; press Enter at the end.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
How to calculate the number of people separately in excel:
1. Open the excel table that needs to be operated and make a table with male and female gender.
#2. Enter the number of men and women in the lower right corner of the table.
3. We enter :=COUNTIF(C1:C13,"Male") in the cell after the number of boys.
4. We enter :=COUNTIF(C1:C13,"Female") in the cell after the number of girls.
#5. Press Enter and you will get the data we want. We successfully used Excel to count the number of men and women separately.
Related learning recommendations: excel tutorial
The above is the detailed content of How to calculate the number of people separately in excel. For more information, please follow other related articles on the PHP Chinese website!