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

[µo°Ý] VLOOKUP ¨ç¼Æ ¬Û¥[°ÝÃD

[µo°Ý] VLOOKUP ¨ç¼Æ ¬Û¥[°ÝÃD

VLOOKUP ¤½¦¡¦p¤U,
=VLOOKUP("F0",D76:H100,2,FALSE)+VLOOKUP("F1",D76:H100,2,FALSE)+VLOOKUP("F2",D76:H100,2,FALSE)+VLOOKUP("F3",D76:H100,2,FALSE)

¦ý¬O¹J¨ì¤@­Ó°ÝÃD,·í·j´MªºÄæ¦ì¤ºµLF0~F3 ®É,·|·Ó¦¨¦^¶Çªº­È¬° #N/A,

½Ð°Ý°£¤F§Q¥ÎIF ¸ò ISERROR ¨Ó³B²z¥~(¨Ò¦p:IF(ISERROR (VLOOKUP("F0",D76:H100,2,FALSE)),"0",VLOOKUP("F0",D76:H100,2,FALSE))+IF.....),
¥i¥H¦³¨ä¥Lªº¤è¦¡¦b²¤Æ¶Ü??

¦^´_ 1# wind6424
±N¿ù»~­È¥H¡u¥Õ¦â¡v¦r³B²z¡A¥i§_¡H

Fig.JPG (117.98 KB)

Fig.JPG

TOP

¦^´_  wind6424
±N¿ù»~­È¥H¡u¥Õ¦â¡v¦r³B²z¡A¥i§_¡H
p212 µoªí©ó 2013-1-24 17:17

¬O¬Ý¤£¨ì¤F,
¦ý¦pªG­nÄ~Äò¤Þ¥Î¸ÓÀx¦s®æ°µ­pºâªº¸Ü, ÁÙ¬O#N/A...

TOP

VLOOKUP ¤½¦¡¦p¤U,
=VLOOKUP("F0",D76:H100,2,FALSE)+VLOOKUP("F1",D76:H100,2,FALSE)+VLOOKUP("F2",D76:H ...¥i¥H¦³¨ä¥Lªº¤è¦¡¦b²¤Æ¶Ü??
wind6424 µoªí©ó 2013-1-24 16:45

¦pªG±z¥Îªº¬OExcel 2007ªº¸Ü, ¥i¥H§ï¦¨¦p¤U:
=IFERROR(VLOOKUP("F0",D76:H100,2,FALSE),)+IFERROR(VLOOKUP("F1",D76:H100,2,FALSE),)+IFERROR(VLOOKUP("F2",D76:H100,2,FALSE),)
Excel 2003 ¦n¹³¨S "IFERROR" ³o­Ó¨ç¼Æ...

TOP

=SUM(SUMIF(D76:D100,{"F0","F1","F2","F3"},E76:E100))

TOP

P212 ¤j¤j,¦]¬°°µ­pºâ,©Ò¥H³o¼Ë¦æ,
·PÁ Jevon ¸ò JBY ¤j¤j ´£¨Ñ²¤Æªº¤½¦¡

TOP

To P212 ¤j¤j,¦]¬°°µ­pºâ¥Î,©Ò¥H³o¼Ë¤£¥i¦æ,
·PÁ Jevon ¸ò JBY ¤j¤j ´£¨Ñ²¤Æªº¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD