Home » Blogs » Nick's blog

29. Excel Tips - Calculating proportions with COUNTIF

Nick's picture
Submitted by Nick on 9 March, 2009 - 09:32

Suppose you have the following data, and you want to calculate the percentage of people who are Male, and the percentage of Females

COUNTIF

Use the COUNTIF function to count the number of each in the range, then divide by the total to get the percentages.

Practise sheet

Training Video on calculating Proportions:

»