Current location - Training Enrollment Network - Mathematics courses - How do spreadsheets count the number of excellent students in two languages and the number of qualified students in two languages?
How do spreadsheets count the number of excellent students in two languages and the number of qualified students in two languages?
It doesn't feel good to provide a feasible way, but it is ok if the quantity is small.

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.