两ç§æ¹æ³ï¼ä¸æ¯ä½¿ç¨ã
æ°æ®éè§è¡¨ãï¼å¨é项å¡ãæå
¥ãéé¢ï¼åè½èªå¨çæ表2ï¼æ éä»»ä½å½æ°åå
¬å¼ï¼äºæ¯ä½¿ç¨SUMIFSå½æ°åå
¬å¼ï¼ä¾å¦ï¼
=SUMIFS(SHEET1!$D:$D, SHEET1!$A:$A, $B3, SHEET1!$C:$C,E$2)
å³æãä¸æå³å¯ã