EXCEL中A列中有相同的名字,F列对应数值 找出名字及对应的最大值,在...答:假设左表数据在A:F列,右表在J:M列,则:K2=COUNTIF(F:F,"<300")K3=COUNTIF(F:F,"<600")-COUNTIF(F:F,"<300")K4=COUNTIF(F:F,"<900")-COUNTIF(F:F,"<600")K5=COUNTIF(F:F,">=900") L2=SUMIF(F:F,"<300")L3=SUMIF(F:F,"<600")-SUMIF(F:F,"<300")L4=...