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

[µo°Ý] ½Ð°ÝÅã¥Ü¡u#N/A¡v¡A­n¦p¦ó¥[Á`

[µo°Ý] ½Ð°ÝÅã¥Ü¡u#N/A¡v¡A­n¦p¦ó¥[Á`

¦P¤@Ä椺¤§Àx¦s®æ¤º¦³¶Ç¦^¿ù»~ªº­È¡A¦pÅã¥Ü¡u#N/A¡v¡A¤]¦³¥¿½Tªº¼Æ¦r¡A­Y¥ÎSUM¨ç¼Æ¥h¥[Á`¾ãÄ椧«á¡A¤]¥X²{¡u#N/A¡vµLªk¥[Á`¡A½Ð°Ý¦³¨ä¥L¨ç¼Æ¥i¥Î¶Ü?
julie

¦^´_ 1# julieh96590

=IF(ISERROR(­ì¨Óªº¤½¦¡),"",­ì¨Óªº¤½¦¡)

TOP

¦^´_ 1# julieh96590

¤£¯à¨Ï¥Î¾ãÄæ°Ñ·Ó
¦³¼ÐÃD¦Cªºª¬ªp­pºâAÄæ¼Æ­È¥[Á`
°}¦C¤½¦¡(Ctrl+Shift+Enter§¹¦¨¿é¤J)
=SUM(IF(ISERROR(A2:A65536),0,A2:A65536))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

ÁÂÁ¤G¦ì¤j¤j¸Ñµª¡A¦b¨C¤@­ÓÀx¦s®æ=IF(ISERROR(­ì¨Óªº¤½¦¡),"",­ì¨Óªº¤½¦¡)¡A´N¤£·|¥X²{#N/A¡A¦ÓHsieh¤j¤jªº¸Ñµª¡A¶È¦b¥[Á`ªºÀx¦s®æ¤U¤½¦¡¡A§Y¥iSUM¥X¨Ó¡A¤£¦b¥G¦³µL¥X²{#N/A¡A¤GªÌ¦U¦³¤d¬î¡AÁ`¤§«D±`ÁÂÁÂ
julie

TOP

¥H¤U¨ç¼Æ»¡©ú,¦³§U¹ï¡u#N/A¡vªº§PÂ_¡C
¨ç¼Æ        ·|¶Ç¦^ TRUE ªº±¡ªp
ISERR        Value «üªº¬O #N/A ¤§¥~ªº¥ô¦ó¤@ºØ¿ù»~­È¡C
ISERROR        Value «üªº¬O¥ô¦ó¤@ºØ¿ù»~­È (#N/A¡B#VALUE!¡B#REF!¡B#DIV/0!¡B#NUM!¡B#NAME? ©Î #NULL!)¡C
ISNA        Value «üªº¬O¿ù»~­È #N/A (µLªk¨Ï¥Îªº¼Æ­È)¡C

TOP

¦³¤èªk¤Þ¥Î¾ã¦C,©Î¬O§½³¡
½Ð°Ñ¦Ò

ZZ5151353.rar (1.41 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

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