å·¦å³ä¸¤ä¸ªæ°æ®åºåãä½ æ³åªä¸ªå¹é
å°åªä¸ªåºï¼
å¦å·¦å¹é å°å³ââDåï¼æ宾Qå¼ï¼å¹é å°Jåï¼
å¨J2è¾å ¥
=SUMPRODUCT((B$2:B$100=G2)*(C$2:C$100=H2)*D$2:D$100)
å车并åä¸å¡«å ã追é®
å¦å·¦å¹é å°å³ââDåï¼æ宾Qå¼ï¼å¹é å°Jåï¼
å¨J2è¾å ¥
=SUMPRODUCT((B$2:B$100=G2)*(C$2:C$100=H2)*D$2:D$100)
å车并åä¸å¡«å ã追é®
请é®å³ç交æéé¢è½å åå å¹é å°å·¦è¾¹çæ宾Qå¼åï¼
追çä¹æ¯ä¸æ ·çï¼å
¬å¼å¼ç¨åè¿æ¥å°±è¡ï¼
å¨E2è¾å
¥
=SUMPRODUCT((G$2:G$100=B2)*(H$2:H$100=C2)*I$2:I$100)
å车并åä¸å¡«å
ã
å
¬å¼èªå¨æ符å两个æ±æ»ã
温馨提示：内容为网友见解，仅供参考
无其他回答
相似回答
