=SUMIF(A1:A10,E4,C1:C10)
“A1:A10”选择求和项列
“E4”选择求和项
“C1:C10”选择数值列