Excel calculates the number of men and women

Suppose, a column of data, save is male or female such sex, below, how can calculate the number of men and women?

Suppose the data range for saving men and women information is: A1:A12 then:

① Calculate male other numbers

=countif (A1:a12, "male")

Use the general formula above to calculate the number of men.

② calculate the number of women in other

=countif (A1:a12, "female")

Use the general formula above to calculate the number of women.

The above two scenarios are common methods of calculation. Use the more flexible formula below.

=countif (a:a, "male")

=countif (a:a, "female")

These two situations, more flexible, because only need to enter the gender in column A, no matter how many rows of data, can be accurate statistics, do not need to specify the scope of the statistics.

Another method is to use the method of filtering, the specific use of the following methods:

First select any cell that has content in column A, then click on the menu "data" → "Filter" → "AutoFilter", which will be in the first row of content there, a Drop-down combo box, click to expand it, found in the inside "Custom", pop-up dialog box.

In the dialog box, display the following selection "equals" in the row, and on its right there, enter male or female, finally, click the "OK" button to exit, you can filter out the data of men or women, this time, in the status bar position, you can see "in the first few records to find X records" of the words, this is the number of statistics.