- ©«¤l
- 19
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-14
- ³Ì«áµn¿ý
- 2020-7-23
|
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Ó¨ç¼Æ... |
|