1. Take this table as an example, you need to count the number of people with 80 points or above in mathematics and English.

2.Enter =COUNTIFS(C2:C22，" & gt=80”，D2:D22，“& gt=80")。

After entering the car, we can see that the result is 3. As can be seen from the table, all three people who meet the requirements are marked.

4. So what does this function mean? COUNTIFS(C2:C22, "& gt=80", D2:D22, "& gt=80") is basically the same as the countif function, except that there is one more data column and one more condition in the function, indicating the number of people who meet both conditions at the same time.