Mẹo nhỏ: Để tìm kiếm chính xác các ấn phẩm của tuyengiaothudo.vn, hãy search trên Google với cú pháp: "Từ khóa" + "tuyengiaothudo". (Ví dụ: vong tay tram huong tuyengiaothudo). Tìm kiếm ngay
COUNTIFS is one of the familiar functions commonly used in Excel. However, most people often have difficulty when they first get used to this function. Understanding that, Hoang Ha Mobile will guide you on how to use the COUNTIFS function to count with conditions, and at the same time introduce some other counting functions in Excel in the most detailed way through the article below. Please refer to it!
[related_posts_by_tax title=""]
What is the COUNTIFS function in Excel?
Before we get to how to use the COUNTIFS function, let’s learn what COUNTIFS is. COUNTIFS is a function that counts the number of occurrences of objects that meet the conditions set forth in certain ranges of a spreadsheet.
COUNTIFS is a function that counts the number of occurrences of an object that meets given conditions.
It can be said that COUNTIFS is an advanced function of COUNTIFS. If COUNTIF only counts cells in a range with a single condition, COUNTIFS has the ability to count cells that meet multiple conditions at the same time in the same range or different given ranges.
In Excel, COUNTIFS is used to:
Count data cells based on various conditions.
Create professional and fast calculations.
Allows combining with other functions in Excel to improve work efficiency.
criteria_range1: This is a required element, used to define the range you want to count, which can contain numbers, an array of data, or a reference containing numbers.
criteria1: Is a required component in the function, understood as the condition that the cell must meet in criteria_range1.
criteria_range2: This is an optional component in the function, used to specify the second data range to count.
criteria2: Similarly, this member is only available if you use criteria_range2 because it is the criteria of the second data range to count cells.
When using COUNTIFS in Excel, you don’t need to memorize the above syntax. Because Excel will automatically display each argument as you type the function name.
Syntax of the COUNTIFS function
Note:
You can use COUNTIFS to count cells that meet a single condition in a given range or multiple conditions across multiple data ranges. In the latter case, the function will count only cells that meet all of the specified conditions.
Each additional data range must have the same number of rows and columns as the initial data range – the criteria_range1 argument, respectively. However, they do not have to be contiguous.
The COUNTIFS function counts up to 127 data ranges.
COUNTIFS will automatically treat a range specified as empty cells as a value of 0.
You can use wildcard characters such as asterisks.
To understand how to use the COUNTIFS function, you can follow the example below:
Case 1
For example, your company is manufacturing and distributing many different types of items (shirts, pants) and you need to count the number of shirts exported with the condition that the quantity must be over 40. Then, you enter the following syntax in the reference box and press Enter to see the result: