Help needed to count members in a sport club.

Asked By 10 points N/A Posted on -
qa-featured

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.

Excel data

 

SHARE
Answered By 0 points N/A #155386

Help needed to count members in a sport club.

qa-featured

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.

Count it Function

Now type the following formula in cell F4.

=countif(C4:C20,20)

Countif function

Then type this formula in cell F5.

=COUNTIF(C4:C20,30)

Countif Function in excel

Type this formula in cell F6.

=countif(C4:C20,40)

Countif Function

Finally, type this formula in Cell F7.

=countif(C4:C20,50)

Countif Functions

Now you can see that no of members in each category can be taken using this formula easily.

Login/Register to Answer

Related Questions