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

[µo°Ý] ©¿²¤ÁôÂ꺭ÈSUBTOTAL ¨ç¼Æ¤å¦r¼Æ­È²Î­p¤§ºÃ´b?

[µo°Ý] ©¿²¤ÁôÂ꺭ÈSUBTOTAL ¨ç¼Æ¤å¦r¼Æ­È²Î­p¤§ºÃ´b?


©¿²¤ÁôÂ꺭ÈSUBTOTAL 102 ¨ç¼Æ¤å¦r¼Æ­È²Î­p¤§ºÃ´b?
Àx¦s®æ¥N½XÄæ¤U I2:I22 ¬°¤å¦r¼Æ­È¤§«¬ºA(­Y¤£Âà´«¼Æ¦r)
¥H¿z¿ï¤§¤è¦¡¿ï¾Ü 1057...
I24²Î­pÄæÀx¦s®æ»Ý¬° 7¥ó
½Ð°Ý¤½¦¡¸Ó¦p¦ó­×¥¿...

0712.rar (7.65 KB)

COUNTIF(I2:I22,1057)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522
¤£¦n·N«ä...
°w¹ï¤W­±©Ò«ü°ÝÃD
¬O«ü¦b I1Àx¦s®æÂI¿ï ©Ò»Ý¥N½X ¤§¿z¿ï
¿z¿ï¤§«á¦b I24 Àx¦s®æ
Åã¥Ü©Ò¿ï¤§¥N½X¤§­Ó¼Æ¦³´X­Ó³á  ^^
¬O§_¯à¦A«×­×¥¿¤½¦¡¬°¦ó

TOP

¦^´_ 3# cypd


    COUNTIF(I2:I22,I1)


)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522
¥H¹Ï¸Ñ»¡©ú¦p¤U:

TOP

¦^´_ 1# cypd


SUBTOTAL: 102 ¬O"¼Æ­È"
103 ¥H"«DªÅ"--¼Æ­È.¤å¦r³£¥]§t
¦ý¬O, ­Y¤º®e¬O¤½¦¡µ²ªGªºªÅ¦r²Å, ¤]·|ºâ¶i¥h~~

TOP

¦^´_ 6# ­ã´£³¡ªL
SUBTOTAL: 102 ¬O"¼Æ­È"
­Y»Ý¥H¦¹¤½¦¡SUBTOTAL: 102
¦pÃD¤º®e¼Æ¾Ú¶·Âà´«¦¨"¼Æ­È"
¤~¯à¶i¦æ¿z¿ï²Î­p   ^^

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