两个å
¬å¼ï¼
1ï¼æçéç»ææ±åï¼å³æ±åç»æéçéèååçï¼ï¼è¿ä¸ªå
¬å¼å¨çéç¶æé常å®ç¨ï¼æ¨èï¼
=SUBTOTAL(9,C2:C1000)
å
¬å¼æ好æ¾å¨C1å
ï¼æ¾å¨Cå1000è¡ä»¥å
ä¼å½¢æ循ç¯å¼ç¨ï¼
2ï¼è¦åæ¶çéåå
¬å¼ç»æä¹ä¸åçï¼å³çäºåºå®æ¡ä»¶æ±åï¼
=sumifs($C$2:$C$1000,$A$2:$A$1000,"3æ",$B$2:$B$1000,"A")
è¿ä¸ªå
¬å¼çæææ¯åæ¡ä»¶æ±åï¼å³æ»¡è¶³â3æâä¸âA"两个æ¡ä»¶åè¿åææ符åæ¡ä»¶çå¼çåã
温馨提示:答案为网友推荐,仅供参考