By Victor Alarsa
In essence, the COUNTIFS function is used to count the number of cells that meet one or multiple criteria, given a specific range of the array.
You may have noticed that COUNTIFS has an “S” in the end, which differs from its cousin COUNTIF, which is programmed to count the number of cells meeting only one condition and a single range, whereas COUNTIFS accepts several criteria.
The formula is comprised of ( criteria range 1, criteria 1 ), this is the required argument. In case you want to add new criteria, just add after the first two arguments
E.g. ( criteria range 1, criteria 1, criteria range 2, criteria 2).
You could add as many criteria as you want. The criteria range accounts for the array you want to count (highlighting them), and the criteria are the condition to be tested against those values.