- ©«¤l
- 91
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 130
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-5-14
- ³Ì«áµn¿ý
- 2020-5-17
|
¦^´_ 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²£¥Í¿ù»~È
¦]¦¹COUNTpºâ¼Æ¦r¼Æ¶q¬°0
¤½¦¡pºâ¹Lµ{
B2=COUNT(INDIRECT(A1:A5))
=COUNT(INDIRECT(5))
=COUNT(#REF!)
=0 |
|