åèå¾ç¤ºï¼
1ãå¤å¶æ¥æåæ°æ®å°ç©ºç½åï¼å¦Fåï¼ç¶åéå®Fåï¼æ°æ®==ãå é¤éå¤é¡¹ï¼è·å¾ä¸éå¤çæ¥ææ°æ®ï¼
2ãåèe2è¾å ¥å ¬å¼
=SUMPRODUCT(($A$2:$A$31=F2)*($B$2:$B$31=SUMPRODUCT(MAX(($A$2:$A$31=F2)*($B$2:$B$31))))*($C$2:$C$31))
å车并ä¸æè·å¾æ¯å¤©å¯¹åºéè¦çæ°æ®ã
æ°æ®è¡¨èå´é æ ä¿®æ¹ã
åæ æé:
æ ¹æ®æ¥çä½ çæ°æ®è¡¨ï¼æ¯å¤©æåä¸ä¸ªæ¶é´åºè¯¥æ²¡æéå¤çï¼å¦æéå¤ï¼è¯¥å ¬å¼è®¡ç®ç»æä¼åºéï¼