I have a list of members in a sport club and their age category. I just want to count how many members is each category. There are thousands of name in my excel sheet. How can I count these members easily by using an excel function. I have showed some of that member in the below image.
- Login or Signup Now to post comments
I will explain you an easy way to get the result that you expected by using an excel function. In this case we are able to use the “Countif” function available in Microsoft excel.
I will take the same example that you took. I will add the categories in front to the table as follows.
Please see the image below.
Now type the following formula in cell F4.
=countif(C4:C20,20)
Then type this formula in cell F5.
=COUNTIF(C4:C20,30)
Type this formula in cell F6.
=countif(C4:C20,40)
Finally, type this formula in Cell F7.
=countif(C4:C20,50)
Now you can see that no of members in each category can be taken using this formula easily.