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

¦³Ãö½d³ò­È°ÝÃD~

¦³Ãö½d³ò­È°ÝÃD~

¦U¦ì°ª¤â¤j¤j­Ì¦n,,,

     ªþ¥ó·Q½Ð°Ý¤@­Ó½d³ò­Èªº¦¸¼Æ,§Ú¨Ï¥Î°}¦C,,©Ò¦³³]©wªº½d³ò³£¦³§ì¨ì¥B¥¿½T,,,¥u¦³¤@­Ó½d³ò­È¥¼¦³°ÝÃD~~·Q½Ð¸Ñ¤½¦¡¬O§_¦³»~~~~ÁÂÁÂ
·PÁ¤£ºÉ!!*20000 20180912.zip (464.74 KB)
yvonne

¦^´_ 1# afu9240

¤£ª¾¹D¬O¤£¬O88¦C¥H«áªºÀx¦s®æ¦³©_©Çªº­È

§Ú§â88¥H¤Uªº¥þ¿ï§R°£

­È´N¥¿±`¤F

¬ö¿ý­È20180912_REPLY.zip (159.54 KB)
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2018-9-12 19:31 ½s¿è

=SUM(((0&D2:D1000)-140>0)*((0&E2:E1000)-90>0))
ªÅ¥Õ®æ¥ç¥i¥Î®ø°£¤º®e
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# hcm19522


   ·PÁ¦^´_*10000 ·P®¦
yvonne

TOP

¦^´_ 2# li_hsien


    ·PÁ¦^´_~~©_©Ç§Ú­ì¥»¦³§R±¼ªü¦ý¤£¯à°õ¦æ,,±z§R±¼«o¥i¥H°õ¦æ~~¯u©Ç~~~~~ÁÙ¬OÁÂÁ±zªº¦^ÂÐ
yvonne

TOP

I44 =COUNTIFS(D:D,LEFT(J44,FIND(",",J44)-1),E:E,MID(J44,FIND(",",J44)+1,99))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089


    ¤j¤j ±z¦n
       ¤£¦n·N«ä¨º³Â±ß¤~¦^±z,,·PÁ±zªº¸Ñ´b!tks
yvonne

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD