ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] countÀx¦s®æ¤º¬Û¦Pªº¤å¦r

[µo°Ý] countÀx¦s®æ¤º¬Û¦Pªº¤å¦r

½Ð°Ý«ç»ò­pºâÀx¦s®æ¤º©Ò¦³«ü©wªº¤å¦r.

=SUMPRODUCT(ISNUMBER(SEARCH("JOHN",E$1:E$100))*ISNUMBER(SEARCH("JOHN",E$1:E$100)))+SUMPRODUCT(ISNUMBER(SEARCH("JOHN",F$1:F$100))*ISNUMBER(SEARCH("JOHN",F$1:F$100)))

=SUMPRODUCT(ISNUMBER(SEARCH("ENTER",E$1:E$100))*ISNUMBER(SEARCH("ENTER",E$1:E$100)))+SUMPRODUCT(ISNUMBER(SEARCH("ENTER",F$1:F$100))*ISNUMBER(SEARCH("ENTER",F$1:F$100)))
ù

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2020-2-4 14:30 ½s¿è

¦^´_ 1# john2006168
¤£¤À¤j¤p¼g
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2020-2-4 15:00 ½s¿è

COUNTIF(A$1:F$9,"*"&G12&"*")

¨ú¤å¦r¤£­«½Æ
https://blog.xuite.net/hcm19522/twblog/588867775
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522


    ÁÂÁÂÀ°¦£.

TOP

¦^´_ 5# john2006168
¦³¨ú¤å¦r¤£­«½Æhttps://blog.xuite.net/hcm19522/twblog/588867775
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD