=SUM(SUM((LARGE(OFFSET(INDIRECT("r"&MATCH(A3,H:H,)&"c8",),,2,4),{3;2;1})-LARGE(OFFSET(INDIRECT("r"&MATCH(A3,H:H,)&"c8",),,2,4),{4;3;2}))*IF(B3="个人",E3:E5,F3:F5)),SUM((LARGE(OFFSET(INDIRECT("r"&MATCH(A4,H:H,)&"c8",),,2,4),{3;2;1})-LARGE(OFFSET(INDIRECT("r"&MATCH(A4,H:H,)&"c8",),,2,4),{4;3;2}))*IF(B4="个人",E3:E5,F3:F5)),SUM((LARGE(OFFSET(INDIRECT("r"&MATCH(A5,H:H,)&"c8",),,2,4),{3;2;1})-LARGE(OFFSET(INDIRECT("r"&MATCH(A5,H:H,)&"c8",),,2,4),{4;3;2}))*IF(B5="个人",E3:E5,F3:F5))) 数组公式 想法中有短点的 但是试了总错误 应该是自己还没理解 |