- The COUNTIF or COUNTIF formula in Microsoft Excel is one of those that you should know how to use
- With it, as a user you can count the number of cells that meet certain criteria or conditions, which will make it easier for you to obtain a count, avoiding having to do it manually
There are certain formulas in Excel that you should learn to use, especially if you are taking your first steps with them. In particular, there are certain ones such as COUNTIF or COUNTIF that will be fundamental when it comes to improving your productivity, so we are going to teach you when to use it and what are the steps you have to follow.
What is it for? Basically, with it you can count the number of cells that meet certain criteria or conditions, which will make it easier for you to get a count, avoiding having to do it manually.
A good example of this is if we want, for example, to know in what number of cells a specific word can be seen, such as if we want to see how many times a name or number appears in the cells. We have the possibility, without going any further, to control expenses by reviewing certain expenditures.
And how to use COUNTIF or COUNTIF formula in Excel?
Let’s suppose then that we have a rather simple inventory, with two columns, with school supplies and the quantities of each one, because they are what our children need. Of course, you can use it however you want.
The first thing you have to do is write, in any of the COUNTIF cells followed by an open square bracket, considering that the range will ask you about the range of cells to verify, while the criteria asks you exactly what are the criteria that Excel should have in consideration when conducting these analyzes.
Therefore, we could assume that it remains a final result similar to this:
You have to make sure to close the brackets, so that that way the formula really works.
As you can see, in the example we just mentioned, we are going to use Pens as the criterion, although we are not going to look for it in the entire document, but specifically between cells G9 and G15.
Limitations of the COUNTIF formula
Unfortunately, we cannot fail to mention that if the COUNTIF formula uses criteria that match a string longer than 255 characters, it will return an error, so it will be unusable.
Another question to consider about the behavior of these tools is that It is not case sensitive, so it will return the same conclusions regardless of them.
Another behavior of COUNTIF functions has to do with the use of wildcard characters, since if we include an asterisk in the COUNTIF criteria, it will match any sequence of characters that have those values.