éæ©æ°æ®åºåï¼æCtrl+Gï¼æâå®ä½æ¡ä»¶âï¼éæ©â空ç½âåç¡®å®ï¼è¾å
¥â空ç½âï¼æCtrl+驾车é®ï¼æææ°æ®åºåä¸ç空ç½åå
æ ¼ä¸ä¼å¡«åâ空ç½âã
ç»è®¡æ年份ç空ç½åå
æ ¼æ°ï¼
æªåä¸é¢çå¡«å
æ¶ï¼
=SUM((A:A=è¦ç»è®¡ç年份)*(B:B="")*1)
åæ¶æCtrl+Shift+Enterä¸é®è¾å
¥æ°ç»å
¬å¼
åäºä¸é¢çå¡«åï¼å³ç©ºç½åå
æ ¼å·²å
¨é¨åäº ç©ºç½ï¼
=SUM((A:A=è¦ç»è®¡ç年份)*(B:B="空ç½")*1)
åæ¶æCtrl+Shift+Enterä¸é®è¾å
¥æ°ç»å
¬å¼
追é®ä½ 好ï¼æä¸ç¥éâæCtrl+驾车é®âä¸ç驾车é®å¨åªéã
å¦ææåäºå¡«å
â空ç½âåæ ·çåå
æ ¼ï¼è¦ç»è®¡æ¯å¹´ä¸â空ç½âåå
æ ¼æ°ç®
åºè¯¥æä¹æä½å¢ï¼
追çä¸å¥½ææï¼äºç¬è¾å
¥æ³ï¼â驾车âä¸âå车âéç ï¼æ²¡éæ©å¯¹ã
好象åé¢å·²ç»è¯´äºï¼=SUM((A:A=è¦ç»è®¡ç年份)*(B:B="空ç½")*1)