How to use the COUNTIF or COUNTIF formula in Microsoft Excel

 How to use the COUNTIF or COUNTIF formula in Microsoft Excel

      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, making it easier for you to get the number, avoiding having to do it manually

  There are certain formulas in Excel that you should learn how to use, especially if you are taking your first steps with them.  In particular, there are some elements like COUNTIF or COUNTIF that will be key when it comes to improving your productivity, so we'll let you know when to use them and what steps to follow.

  Why this?  Basically, you'll be able to count the number of cells that meet certain criteria or conditions, making it easier for you to get the count, by avoiding having to do it manually.

  A good example is if, for example, we want to know how many cells a particular word can be seen, such as if we want to know how many times a name or number appears in the cells.  We have the possibility, without going any further, to control the expenses by reviewing some of the expenses.

  How do you use the COUNTIF or COUNTIF formula in Excel?

  Suppose then we have a fairly simple stock, with two columns, with the school supplies and quantities of each one, because they are what our children need.  Of course, you can use it as you like.

  The first thing you need to do is to type, in any of the COUNTIF cells followed by an open square bracket, keeping in mind that the range will ask you what range of cells to check, while the criteria will ask you exactly what criteria Excel uses to take into account when doing these analyzes  .

  Therefore, we can assume that a final result similar to this is left

  = COUNTIF (G9: G15, "pens")

  You have to make sure the parentheses are closed, that way the formula really works.

  As you can see, in the example we just mentioned, we'll use pens as a benchmark, although we won't be searching for them throughout the document, but specifically between cells G9 and G15.

  COUNTIF Excel 2

  Limitations of the COUNTIF Formula

  Unfortunately, we can't fail to point out that if the COUNTIF syntax uses criteria that matches a string longer than 255 characters, it will return an error, making it unusable.

  Another thing to keep in mind about the behavior of these tools is that they are not case sensitive, so they will return the same conclusions, no matter what.

  Another behavior of COUNTIF functions relates to the use of wildcards, because if we include an asterisk in the COUNTIF criteria, it will match any sequence of characters containing those values.