How to find the total number of people in excel

How to find the total number of people in Excel?

1. First, enter the data to be calculated as a proportion in the cells of the excel table.

Recommended: "excel tutorial"

2. Then enter the proportion calculation formula in cell C1: =B2/ 810, which means dividing the "number of undergraduate students" by the total number of students.

#3. Click Enter to generate calculation results. Double-click the green dot in the lower right corner to generate calculation results in batches.

#4. After all calculation results are generated, you can see that decimals are displayed and need to be converted into percentages.

5. Right-click the cell and select Format Cells. In the dialog box that opens, select "Percent" and select "2" for the number of decimal places. Click Sure.

#6. You can change the proportion value to a percentage display.

The above is the detailed content of How to find the total number of people in excel. For more information, please follow other related articles on the PHP Chinese website!