å
¬å¼ä¸æ¯é®é¢ï¼å¾ç®åï¼å
³é®æ¯ä½ è¦è®¾è®¡ä½ çè¡¨æ ¼ã
ä½ å¯ä»¥ä¸ä¸ªæä¸ä¸ªEXCELæ件ï¼è¿ä¸ªæ件æ两个工ä½è¡¨ï¼ä¸ä¸ªè®°å½æµæ°´ï¼æä¸é¢è¿äºåï¼
A æ¥æ
B å§å
C åºè¡¬
D 帮é¢
æ¬è¡¨æææ°æ®é½æ¯æå·¥è¾å
¥ï¼æ¯å¤©è®°å½ã
å¦å¤ä¸ä¸ªè¡¨å°±æ¯ä½ è¿ä¸ªæçå·¥èµæ±æ»è¡¨ï¼æ ¼å¼å°±æ¯ä½ ç»çæ ·åï¼
A å§å
B åºè¡¬
C 帮é¢
D å·¥èµ
æ¬è¡¨çå§ååæ¯æå·¥è¾å
¥ï¼å
¶ä½åå使ç¨å
¬å¼ï¼
BåCåçå
¬å¼ç±»ä¼¼ï¼ä½¿ç¨SUMIFä»æµæ°´è¡¨ä¸æ±æ»ï¼æ¯å¦B2çå
¬å¼ä¸ºï¼
=SUMIF(Sheet1!$B$2:$B$10000,A2,Sheet1!$C$2:$C$10000)
C2çå
¬å¼ä¸ºï¼
=SUMIF(Sheet1!$B$2:$B$10000,A2,Sheet1!$D$2:$D$10000)
D2çå
¬å¼ä½ ä¼åå§ï¼ä¸»è¦æ¯ç¥éåºè¡¬ã帮é¢çåä»·ï¼ä¾å¦D2çå
¬å¼ä¸ºï¼
=B2*894/330 + C2*885/330
温馨提示:答案为网友推荐,仅供参考