COUNTIFS is another Excel function that allows you to count the number of cells that meet multiple criteria within a range. This function is useful when you need to count the number of times a particular combination of values or conditions appears in a range of cells.
For example, let's say you have a list of exam scores and you want to count how many students scored above a certain threshold in a particular subject. You can use the COUNTIFS function to count the number of cells that meet both criteria:
The syntax for COUNTIFS function is as follows:
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
• criteria_range1: the first range of cells that you want to evaluate.• criteria1: the first condition that must be met for a cell to be counted.• [criteria_range2, criteria2]: additional ranges and conditions that must be met for a cell to be counted. You can include up to 127 ranges and criteria.