ããæé®è
å¾ç®åï¼ä¸æä¾å·¥ä½è¡¨æ°æ®ç»æï¼ç»åçè
带æ¥æ大çä¸æ¹ä¾¿ãä¸åé çæµï¼ç»æå¾é¾ç¬¦åæé®è
çè¦æ±ãæ¤é¢å³å
¸åçæ
åµãä¸é¢è´´ä¸å¾ï¼è¯´æ对Aåçéåï¼æ±Båä¸xç个æ°ï¼å
¬å¼ï¼
ãã=SUM(SUBTOTAL(3,OFFSET(B1,ROW(B1:B42),))*(B2:B43="x"))
ããææCtrl+Shift+Enterä¸é®è¾å ¥æ°ç»å ¬å¼ã