If conditions are related to multiple columns, then we use the COUNTIFS function, which we will discuss in the later article.If the conditions are related to one specific column, we will apply the COUNTIF function in a single column, as discussed in the above article.First, analyze the problem and condition mentioned.After passing all the conditions one by one, in the end, add all the results.A third will again select the range of cells from D40:D51 and will pass the 3 rd condition, “May”.Second, we will again select the range of cells from D40:D51 and will pass the 2 nd condition, “Feb”.First, we will select the range of cells from D40:D51 and will pass 1 st condition, “Jan”.We will apply the COUNTIF formula as follows: Here, we will calculate the sum of products who sold out in the month of Jan, Feb & May. Let’s take the same product details again. We pass the condition one by one and, in the end, sum all the results.The COUNTIF formula will apply as follows: Here we will calculate the count of items which is greater than 12 and less than 30. In this example, we will use a COUNTIF function between two numbers. After applying all the given conditions, sum up all the results to find out the final conclusion.Again will take the same range and 2 nd condition under COUNTIF function and so on… First will take the range and 1 st condition under COUNTIF function. Here, we will apply the condition one by one.= COUNTIF(range, criteria1) + COUNTIF(range, criteria2) + ……. Let us understand the working of the COUNTIF Function by some COUNTIF Formula example. How to Use COUNTIF Function with Multiple Criteria? Thus, the COUNTIF function can be entered in a cell-like below screenshot: Here in this article, we will discuss the COUNTIF Function with multiple criteria in the same column.Īs we know, the COUNTIF function is a built-in function in excel, and it falls under the FORMULAS tab. It can be a number, text string, cell reference, or expression. Criteria: This defines the condition that tells the function of which cells to count.The COUNTIF Formula has two arguments, i.e. COUNTIF Function with multiple criteria in multiple columns.COUNTIF Function with multiple criteria in the same column.There can be two ways for multiple counting: Excel functions, formula, charts, formatting creating excel dashboard & others