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

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

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

0712.png
2020-7-12 17:50

©¿²¤ÁôÂ꺭È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)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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)


)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522
¥H¹Ï¸Ñ»¡©ú¦p¤U:
07121.jpg
2020-7-12 23:34

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 : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD