Do you really know how to use the artifact COUNTIF function in Excel?
Hello, everyone!
I am Chang Xiaoan, a student who has studied Excel with Akiba for many years and has made a successful debut.
I heard that people in the company often ask for leave recently, and the boss asks the new employees to count the number of absenteeism each month:
There are many ▲ data series, only some of them show that the employee painstakingly counted the number of x in front of his boss, smiling all over his face.
But the boss's eyes don't seem very friendly.
Is it true that the forks in attendance records can only be counted one by one?
Of course not. Today, Xiao an will share with you a function commonly used in your work: COUNTIF, which can easily solve the above problems.
1. Introduction to the function COUNTIF can count the cells in a specified range that meet the specified conditions
The syntax rules for this function are as follows:
= COUNTIF (range,criteria)
Translate:
= COUNTIF (counting area, counting condition)
There are only two parameters for this function, which is very simple, and rookies can also easily learn!
Next, let's look at the example: use the COUNTIIF function to count the number of absenteeism.
2. Case operation: first of all, in the following data, √ stands for attendance and x represents absence.
Now we need to count the number of days of absence for each person in May!
It's actually very simple! Just enter the formula in the B3 cell:
Then drop down and fill in the formula, which is fine!
Meaning of the formula:
= COUNTIF (C3pura AG3jig3) Parameter ❶: C3:AG3 is the counting area: represents the attendance record within 31 days of May.
The parameter ❷: $junk 3 is the conditional region: J3 cell content is x, which means that x is counted.
J3 cell content is x, that is, the condition for counting is x, and an absolute reference is required to ensure that the reference does not offset when the formula is filled.
Well, this is the end of the introduction to the use of COUNTIF. Is it super simple and practical?
Attendance is √, absenteeism is X, do you know several ways to tick and cross quickly?
This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Chang Xiaoan
