For example, A 1 B 1 is the result of China's mathematics. You enter = if ((and (a1> 80,b 1 & gt; 80)), 1, 0) This sentence means that if both A 1 B 1 are greater than 80, 1 will be displayed, otherwise 0 will be displayed. Then everyone copied this formula at the back. You can count the data in this column again. I don't feel so good. I didn't think of a better way, I'm sorry.