Current location - Training Enrollment Network - Mathematics courses - Excel sum by conditions
Excel sum by conditions
If the data you want is: the total score of each student whose English score exceeds 100, that is = IF(E2 & gt;; = 100, C2+D2+E2, "English score 100 or below")

Then pull down;

If the English score is greater than 100, the total score of Chinese and mathematics =sumif(C:C, e: e > = 100), and the math is =sumif(D:D, e: e > = 100)