(SUMPRODUCT(E7:I7,(E7:I7>K7)1,(E7:I7=K7)(E7:I7

来源：学生作业帮助网编辑：六六作业网时间：2024/12/25 01:11:26

(SUMPRODUCT(E7:I7,(E7:I7>K7)*1,(E7:I7=K7)*(E7:I7(SUMPRODUCT(E7:I7,(E7:I7>K7)*1,(E7:I7=K7)*(E7:I7(SUM

(SUMPRODUCT(E7:I7,(E7:I7>K7)*1,(E7:I7=K7)*(E7:I7
(SUMPRODUCT(E7:I7,(E7:I7>K7)*1,(E7:I7=K7)*(E7:I7

(SUMPRODUCT(E7:I7,(E7:I7>K7)*1,(E7:I7=K7)*(E7:I7
SUMPRODUCT(E7:I7,(E7:I7>K7)*1,(E7:I7=K7)*(E7:I7