Use of COUNTIF with Multiple Criteria - Excel
COUNTIF function helps to count the number of certain value in a list. We can also use multiple criteria for counting. We use this method to calculate multiple criteria in the same or different field. Actually it is the sum of the simple countif functions in one.