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

[µo°Ý] ¦p¦ó­pºâ¿z¿ï¦Z¥]§t­«½Æ¸ê®Æªºµ§¼Æ

[µo°Ý] ¦p¦ó­pºâ¿z¿ï¦Z¥]§t­«½Æ¸ê®Æªºµ§¼Æ

demo.rar (5.78 KB)

½Ð°Ý§Ú­n«ç»ò¦bA2¿z¿ï¦Z¡AÅýA1¦Û°ÊÅã¥Ü¥]§t­«½Æ¸ê®Æªºµ§¼Æ¡H
²{¦bÅã¥Üªº5¬OÁ`¦@¦³ A,B,C,D,E ¤­µ§¸ê®Æ¡A
§Ú·Q­nªº¬O¡G¦bA2¿z¿ïÅã¥ÜA,B¦Ó¤w¡AµM«áA1­ì¥»ªº"5" ­nÅܦ¨ ¡§2¡¨¡C

ÁÂÁ¡C

A1

{=COUNT(0/(MATCH(A3:A30,IF(SUBTOTAL(3,OFFSET(A2,ROW(3:30)-2,)),A3:A30),)=ROW(3:30)-2))}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 2# zz5151353


    ²×©ó¦¨¥\¤F¡I ÁÂÁ¡I ^^

TOP

¦^´_ 2# zz5151353


SUBTOTAL(3, ¥Î±o¦n¡AÆg

¥Î SUBTOTAL(103, ¤]¥i¥H¡A

3¬O¥]§tÁôÂíÈ
103¬O¤£¥]§tÁôÂíÈ
¦n¹³2­Ó³£¥i¥H?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦³©T©wÄæ¦ì¤]¥i¥H¥Î

=SUMPRODUCT((1/COUNTIF(A3:A14,A3:A14))*SUBTOTAL(3,OFFSET(A3,ROW(3:14)-3,)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD