COUNTIFS

Definition: COUNTIFS is a function that counts the number of cells in a range that meet multiple specified conditions.

Syntax: =COUNTIFS(range1, criteria1, [range2], [criteria2], …)

Situation: This formula is suitable when you need to count the number of cells in a range that meet multiple specified conditions, such as counting the number of cells with a value greater than 5 and less than 10.

Example: If you have a range A1:A10 with some cells containing numbers, the number of cells containing numbers between 5 and 10 can be found using the formula =COUNTIFS(A1:A10, “>5”, A1:A10, “<10"), which returns the count of cells containing numbers between 5 and 10.