å设Båæ¯æ§å«å,Cåæ¯å¹´é¾å,ä»20å²å¼å§ç»è®¡,æ¯5å¹´ä¸ä¸ªç»
=SUMPRODUCT((B2:B1000="女")*(C2:C1000>14+ROW(A1)*5)*(C2:C1000<20+ROW(A1)*5))
å
¬å¼ææ为ç»è®¡ç¬¬2è¡è³ç¬¬1000è¡,Bå为女,Cåå¹´é¾å¨å¤§äº19å²,å°äº25å²(å³20~24å²)ä¹é´ç人æ°
å
¬å¼ä¸æå¤å¶è³ä¸ä¸è¡æ¶åæ¯ç»è®¡Bå为女,Cåå¹´é¾å¨å¤§äº24å²,å°äº30å²(å³25~29å²)ä¹é´ç人æ°
温馨提示:答案为网友推荐,仅供参考