Counting Specific Text Values On Any Cells in Excel
Do you struggle to count specific text values within your Excel spreadsheets? Imagine you have lists of students with homework statuses marked as either “Done” or “Not Yet”.
Counting each occurrence manually can be tedious and time-consuming, especially as your dataset grows. Fortunately, there’s a smarter way to handle this task without the hassle of sorting each entry individually.
The Problem
Could we count specific text in Excel? For example, if we have lists of students with their homework, there are two types of data: “Done” and “Not Yet”. How do you count each one of them?
Well, you could sort it and then count it, but it took more time. So, instead of using that, I want to introduce you to a formula that will finish that job: “countif”. This formula will count every specific text on a specific cell.
=COUNTIF(Range, Criteria)
- Range refers to the range of cells you want to search within.
- Criteria refers the specifies the condition or text value you want to count.
Implementing that formula will count every cell containing “Done” and “Not Yet” inside our tables. Well, you could change it with whatever text you want to look for.
It can work for multidimensional tables, and what makes it great is that whenever you change any values on your table, the results will be changed, too.
Conclusions
In this tutorial, I have already told you about the COUNTIF formula in Excel; it helps us calculate anything more efficiently. Well, use it in your work from now on. Thanks for reading. Stay tuned for the following articles.
