Learn Excel COUNT Function.

Career Guidance
1 follower
Nov 4, 2024
Service desk Analyst complete course
https://www.udemy.com/course/it-support-help-desk-service-desk-analyst-crash-course/?referralCode=2BEA91E82EF0A43B7F09
Citrix virtual apps and Desktop complete course
https://www.udemy.com/course/citrix-virtual-apps-and-desktops-7x/?referralCode=B4AFFADD3E44142E746D
please do use the above link only while buying the course so I will get max amount.
We'll be looking at the count function.
The count function is an imbued function in Excel that counts with number in a range.
The count function is an imbued function in Excel that counts cells with numbers in a range.
It is written as equal to count.
Take note that the count function only counts cells with numbers, not cells with letter.
To count cells that have letter, the count if function is better used.
Let's look at an example of how you can use the count function in Excel.
For example, we want to count the total staffs.
We simply use equal to, count, open bracket.
Now we select the range.
We're counting the job title or you can count the employee ID.
Now we have nine.
So this shows us how many staffs we have in this organization, which is nine.
The count function is quite straight to the point.
However, remember the count function only works for cells with numbers.
Let's try to count this job title and see if we can get an output where we have zero.
Why is that?
Because the job title is text.
Let's try to count the salary column and see if we get an output.
Remember, the count function is not the same as sum.
For sum, we are summing all the salaries.
But for count, we are counting individual rows.
So one, two, three, four, five, six, seven, eight, nine, which is why we have nine.
Now notice that the count function worked for the employee ID.
It worked for the salary but did not work for the job title.
Why?
Because the job title is text.
Now let's use the countA function to see if the job title would give us an output.
Now we have it.
Counts columns with text.
You use the countA function to count.
Now the next function we'll be looking at is the countIf function.
