In this we are going to see how COUNT functions work inside Excel.
Let's have this data table prepared in an Excel Sheet.
After typing above table, let's try some COUNT functions.
First lets's count number of Employees using the Employee Name column. To do that you cannot use the COUNT function.
Why ?
Because, the COUNT function only counts number of cells that has numbers and the Employee Name column has text values. So you can use the COUNTA function instead of COUNT function.
Type the function as follows:
=COUNTA(A2:A31)
Output will be 30.
Alternatively you can use COUNT function but with using a column like Height or Weight.
To further experiment this function let's delete the names of Jacob Mitchel & Ryan Hill.
This will update the COUNTA output to 28.
Undo and take those two names back.
Next let's count the number of blank cells from the Department column which that Employees did not assigned for a department yet. To do that type the function as follows:
=COUNTBLANK(B2:B31)
Output will be 4
To experiment, let's add Micheal Williams to Finance. See how the number changed from 4 to 3.
Then add Sophia Robinson to Management.
Next Ryan Hill to Marketing.
Finally Amelia Scot to Management.
As you can see now number of Employees who doesn't have a department is 0.
Next let's get the count of Employees from New York.
For this we need to use the COUNTIF function. The criteria is "The city should be New York".
To do that, type the function as follows:
=COUNTIF(G2:G31, "New York")
This will give the number of Employees from New York as 3.
Further you can try the following questions.
Count the number of Employees from "Seattle".
Count the number of Employees who are assigned to "IT" department.
Count the number of "Female" Employees.
Then let's try getting number of Employees who have height greater than 65 inches.
To do that, type the function as follows:
=COUNTIF(F2:F31,">65")
This will give the Employees who are taller than 65 inches as ____
Further you can try the following questions.
Count the number of Employees who are shorter than 70 inches.
Count the number of Employees who are getting a salary greater than "$ 60,000.00".
Count the number of Employees who weigh than 200 lbs.