COUNTIF Syntax ExplainedĪ small function in COUNTIF in terms of arguments is required but the criteria element can be so many things, so let’s look at several.Īs per COUNTIF function Excel, it defines this as “the range of cells from which you wish to count nonblank cells”. Strictly speaking, you can use this function to count blank cells if you want to. This can be a number of different conditions, from matching text, numbers, cells containing text, matching part text, and more. It looks in a given range and counts the number of times a cell meets a given condition. What is COUNTIF in Excel?īriefly, this function is a more diverse version of COUNT. So, by the end of this article, I hope you will learn how and where to use these conditional counting functions in your daily work. Besides, we will be able to count cells with values that meet a certain condition specified in the formula.
With these functions solely or in collaboration with other functions, we will be able to count the number of cells that contain certain texts, numbers, count blank cells, and non-blank cells. We all know that Excel has a variety of built-in functions, but did you know that the most used functions in Excel are the functions that count and sum? So today, I am happy to discuss and explain (the best I could!) these functions under the statistical category specifically those used for conditional counting – COUNTIF, COUNTIFS, and COUNTBLANK. Excel COUNTIF Function (Introduction to Conditional Counting)