29. Excel Tips - Calculating proportions with COUNTIF

Suppose you have the following data, and you want to calculate the percentage of people who are Male, and the percentage of Females
Use the COUNTIF function to count the number of each in the range, then divide by the total to get the percentages.
Training Video on calculating Proportions:
»
- Nick's blog
- Login or register to post comments
- 50108 reads
Recent comments
6 years 4 weeks ago
6 years 42 weeks ago
7 years 2 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 11 weeks ago
7 years 19 weeks ago
7 years 19 weeks ago
7 years 20 weeks ago
7 years 20 weeks ago