Friends who often make tables often encounter the countif function and the countifs function. Some people are confused. What is the use of this function? Next, let's look at the use methods and differences of these two functions with our friends?
Countif (region, condition)
Countifs (Region 1, Condition 1, Region 2, Condition 2,...)
Because the countif function itself is used to calculate the number of qualified functions, the simple understanding of the two formulas is to set a condition and calculate the number of qualified functions in this area?
Operation method
The first step is of course the simplest. Right click - New - Excel file, and double click to open the file (ps: if you want to rename, just click the file name by left clicking or find the rename by right clicking the drop-down arrow)
After opening the file, in order to make it easy for everyone to understand, the young lady coded some words. Let's take these as examples
Next, let's move on to our example part. Let's first give an example of the countif function; Assume that the number of calculated amount is more than 70? Condition (amount>70) area is included in the required condition (B2: B13)
After understanding the countif function through the above explanation, the next step is to input the formula completely.=COUNTIF (B2: B13, ">70") When entering the formula conditions, the double quotation mark input must be in English, otherwise it cannot be calculated
Next, let's use the countifs function to calculate. Suppose the number of items with amount>70 and quantity>30 is calculated= Countifs (Area 1, Condition 1,...) Condition 1 (amount>70), Area 1 (B2: B13), Condition 2 (quantity>30), Area 2 (C2: C13) are the areas required by the condition. Remember to select correctly
When we input the formula in its entirety, it is=COUNTIFS (B2: B13, ">70", C2: C13, ">30"). Remember that the double quotation marks of conditions are entered in English
Through two examples, we can clearly see that the common points of the countif function and the countifs function are (region, condition), the region contains the selected conditions, the difference is that the countif function condition can only be one, and the simpler countifs function condition region can be multiple. When the number of conditions we require is not single, we can choose the countifs function