Help needed to count members in a sport club.

Asked By Diana Faulconer 10 points N/A Posted on - 08/21/2012

I have a list of members in a sport club and their age category. I just want to count how many members are each category. There are thousands of names in my excel sheet. How can I count these members easily by using an excel function. I have shown some of that member in the below image.

 

• Status: Open
• Question Views: 990
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 0 points N/A #155386

Help needed to count members in a sport club.

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 excels.

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.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Excel