The COUNTIFS function applies the condition to cells across multiple regions, and then counts the number of times all the conditions are met.
grammar
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
The COUNTIFS function syntax takes the following arguments:
■criteria_range1: Required, where the first area of the association condition is calculated.
■criteria1: Required, conditional in the form of numbers, expressions, cell references, or text, defines the range of cells to be counted.
For example, a condition can be expressed as 32, “> 32”, B4, “apples” or “32”.
■criteria_range2, criteria2,… : Optional, additional region and associated conditions. A maximum of 127 region/condition pairs are allowed.
Important: Each additional field must have the same number of rows and columns as the criteria_range1 argument. These areas need not be adjacent to each other.
Instructions
■ Conditions for each zone apply to one cell at a time. If all the first cells satisfy their association condition, the count is increased by 1.
If all of the second cells satisfy their association condition, the count is increased by another 1, and so on until all cells have been counted.
■ If the condition argument is a reference to an empty cell, COUNTIFS will treat the value of that cell as 0.
■ You can use wildcards in conditions, i.e., question marks (?) And an asterisk (*). The question mark matches any single character, and the asterisk matches any string.
If you want to find the actual question mark or asterisk, type the waveform character (~) before the character.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/