Ans: The COUNTIFS() function counts the number of times a given set of conditions exists in a range. The syntax is =COUNT
If all the above formulas seem to be difficult, try out the COUNTIFS() function. It is much more efficient in evaluating multiple conditions compared to using multiple COUNTIF() functions. For example, =COUNTIFS(A2:A10,”alpha”, “bravo".