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

[µo°Ý] INDIRECT¨ç¼Æ

[µo°Ý] INDIRECT¨ç¼Æ

¥»©«³Ì«á¥Ñ kasa ©ó 2017-6-4 22:56 ½s¿è

¥HCOUNT·|­pºâ¥]§t¼Æ­ÈªºÀx¦s®æ¼Æ¥Ø¨Ó´ú¸ÕINDIRECT¨ç¼Æ¥\¯à¦pªþ¥ó,¦ýÁÙ¬O¤£À´¬°¦ó·|¦³¦p¦¹®t²§
½Ð¦U¦ì¤j¤jÀ°¦£¸Ñ´b
ÁÂÁÂ


TEST.zip (7 KB)

¦^´_ 1# kasa


    B2·|¥X²{°ÝÃD¡A¬O¦]¬°INDIRECT¬O±N¤å¦r¦êÂনÀx¦s®æ°Ñ·Ó­n©ñ¤J¬O¤å¦r¡A¦ý§A©ñ¤Jªº¬OÀx¦s®æ½d³ò
©Ò¥H¥L·|¥ý§âÀx¦s®æ½d³ò¤ºªº­È¥ý©â¥X¨Ó¦AÂà¤Æ¦¨Àx¦s®æ°Ñ·Ó¡A¦ý¨ú¥Xªº­ÈµLªkºc¦¨Àx¦s®æ°Ñ·Ó¡A©Ò¥H²£¥Í¿ù»~­È
¦]¦¹COUNT­pºâ¼Æ¦r¼Æ¶q¬°0

¤½¦¡­pºâ¹Lµ{
B2=COUNT(INDIRECT(A1:A5))
     =COUNT(INDIRECT(5))
     =COUNT(#REF!)
     =0

TOP

B2§ï=COUNT(INDIRECT("A1:A5")) §Y OK =5
ù

TOP

·PÁÂnaruto018¤Îrouber590324¨â¦ì¤j¤j~
³z¹L¨â¦ì¤j¤jªº»¡©ú»P¤½¦¡½Õ¾ã½d¨Ò,§¹¥þ²M·¡¤F^^

TOP

¦A½Ð±Ð¤@­Ó°ÝÃD
1.­Y¤½¦¡¼g¦¨=COUNT("A"&ROW()-2&":"&"A"&ROW()+2),¿é¥Xµ²ªG¬°0,³o¬O¦]¬°""ÅýCOUNT»{©w¬A¸¹¤º²Õ¦¨¬°¦r¦ê,¦]¦¹¿é¥X¬°0¹ï§a?
2.«áÄò­YCOUNT¨ç¼Æ¤º¤§½d³ò°Ñ·Ó¥²¶·­n¦³¦p²Ä¤@ÂIªº¼gªk,¶Õ¥²±o·f°tINDIRECT¨ç¼Æ¨Ó¨Ï¥Î¹ï¶Ü?
·PÁÂ~~~

TOP

¥HCOUNT·|­pºâ¥]§t¼Æ­ÈªºÀx¦s®æ¼Æ¥Ø¨Ó´ú¸ÕINDIRECT¨ç¼Æ¥\¯à¦pªþ¥ó,¦ýÁÙ¬O¤£À´¬°¦ó·|¦³¦p¦¹®t²§
½Ð¦U¦ì¤j¤j ...
kasa µoªí©ó 2017-6-4 22:55


B1 ´£¨Ñ¥t¤@«äºû

=COUNTIF(INDIRECT("RC[-1]:R[4]C[-1]",),"<>")
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD