![]() Similarly, we can see in the table that our criteria are in the cell range of D3:D21. The second required criteria is the place of origin is in Thailand. Then enter our criteria >5000 in criteria1. This criterion is in the cell range E3:E21, so we should enter E3:E21 in range1. Our first criterion is sales volume greater than 5000. Range1 is the data area we want to count, criter ia 1 is the required criterion. Select the cell, click the Formulas tab, and click the Insert Function button to find the COUNTIFS function. Therefore, we can use the COUNTIFS function. ![]() O ne, the sales volume needs to be greater than 5,000, and the other is that the place of origin needs to be in Thailand. Now we want to count how many types of foods are produced in Thailand and also have a sales volume of more than 5,000? There are two criteria that we want to consider. The grammatical structure of COUNTIFS is COUNTIFS (range1, criteria1. We often need to count the number of data in our work, so how can we count them quickly? Here, we need to use a new function, COUNTIFS.
0 Comments
Leave a Reply. |