title: Excel: Counting number of male and female employees
body: <p>It might be a basic question but I'm struggling to come up with a function. I have two columns on a spreadsheet: Employee ID and Sex (Male=1). A sample data is as follows: <a href="https://i.stack.imgur.com/4Ox5H.png" rel="nofollow noreferrer">CAPTURE IMAGE</a></p>
  
  <p><a href="https://i.stack.imgur.com/4Ox5H.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4Ox5H.png" alt="enter image description here"></a></p>
  
  <p>Each data entry is an unique observation, and I want to count the number of males and females. For example, there are 2 females and 1 male employee out of 32 observations. What forumula can I use to calculate the numbers?</p>