ä¾å¦ï¼å¦æä¸æä¸ç³»ååå æ ¼B1ï¼B5ï¼å¹¶ä¸æ¯ä¸ªåå æ ¼å å«ä¸ä¸ªææ¬å符串å¼ï¼åå ·æä¸åçå符串é¿åº¦ã并ä¸æ¨æ³è¦ç»è®¡æ¯ä¸ªåå æ ¼çå符串é¿åº¦å¤§äºæ°å10çæ°éã
ä½ å¯ä»¥æ ¹æ®SUMPRODUCTå½æ°ï¼Nå½æ°åLENå½æ°å建ä¸ä¸ªæ°çå ¬å¼æ¥æ£æ¥æ¯ä¸ªåå æ ¼çå符串é¿åº¦ï¼å¹¶è·å¾å符串é¿åº¦å¤§äº10çæ»æ°ãæ以让æ们åä¸é¢çå ¬å¼ï¼
=SUMPRODUCT(N(LEN(B1:B5)>10))
æè ï¼
=SUMPRODUCT(--(LEN(B1:B5)>10))
ç¸å ³å½æ°
Excel SUMPRODUCT å½æ°
Excel SUMPRODUCTå½æ°å°ç»å®çä¸ä¸ªæå¤ä¸ªæ°ç»æèå´ä¸çç¸åºç»ä»¶ç¸ä¹ï¼å¹¶è¿åè¿äºäº§åçæ»å.SUMPRODUCTå½æ°çè¯æ³å¦ä¸ï¼=SUMPRODUCTï¼array1ï¼[array2]ï¼â¦ï¼â¦
Excel LEN å½æ°
Excel LENå½æ°è¿åææ¬å符串çé¿åº¦ï¼ææ¬å符串ä¸çå符æ°ï¼.LENå½æ°çè¯æ³å¦ä¸ï¼= LENï¼textï¼â¦
Excel N å½æ°
Excel Nå½æ°å°å¼è½¬æ¢ä¸ºæ°å¼ãNå½æ°çè¯æ³å¦ä¸ï¼=N(value)