COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
Example 1: Count the cells within A1 and A4 if they are between 100 and 200:
=COUNTIFS(A1:A4,">100",A1:A4,"<200")
Example 2: Count the number of times Yes occurs on the same row within the ranges A1:A4 and B1:B4:
=COUNTIFS(A1:A4,"Yes",B1:B4,"Yes")
Example 3: Count the number of times text beginning with a Y occurs on the same row within the ranges A1:A4 and B1:B4:
=COUNTIFS(A1:A4,"Y*",B1:B4,"Y*")
For more info, see COUNTIFS function
COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
Example 1: Count the cells within A1 and A4 if they are between 100 and 200:
=COUNTIFS(A1:A4,">100",A1:A4,"<200")
Example 2: Count the number of times Yes occurs on the same row within the ranges A1:A4 and B1:B4:
=COUNTIFS(A1:A4,"Yes",B1:B4,"Yes")
Example 3: Count the number of times text beginning with a Y occurs on the same row within the ranges A1:A4 and B1:B4:
=COUNTIFS(A1:A4,"Y*",B1:B4,"Y*")
For more info, see COUNTIFS function
