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

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

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

½Ð°Ý«ç»ò­pºâÀx¦s®æ¤º©Ò¦³«ü©wªº¤å¦r.
test.png
2020-2-4 09:23

=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
¥¼©R¦W.png
2020-2-4 14:29
¾Ç®üµ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
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522


    ÁÂÁÂÀ°¦£.

TOP

¦^´_ 5# john2006168
¦³¨ú¤å¦r¤£­«½Æhttps://blog.xuite.net/hcm19522/twblog/588867775
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD