- ©«¤l
- 14
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 42
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-14
- ³Ì«áµn¿ý
- 2022-11-2
|
=SUM('[1¤ë.xls]1'!H5,'[1¤ë.xls]2'!H5,'[3¤ë.xls]3'!H5,'[1¤ë.xls]4'!H5,'[1¤ë.xls]5'!H5,'[1¤ë.xls]6'!H5,'[1¤ë.xls]7'!H5)
³o¬Oì©lµ{¦¡½X¥i¥H°õ¦æ¥[Á`¡A¥[Á`ªº¦ì¸m³£¬O¦P¤@ÓH5¡A¥u¬O¤é´Á¤u§@ªí¦W¤l¤£¦P¡A
¦]¬°n±`§ï¤é´Á©Ò¥H·Qn±N¤u§@ªí1~7³]¬°¥iÅÜ§óªº ¨Ò¦p1~7¤U¦¸§ï¬°8~14¡A15~21 ¤]¦³¥i¯à¸ó¤ë ©Ò¥H1¤ë¤]¦³¥i¯à§ï¬°2¤ë
¦³¨Ï¥ÎCONCATENATE(1¤ë.xls],1,'!H5)¡A¦ý¬OSUM´N·|Åã¥Ü¿ù»~ ¡A½Ð°Ý¦U¦ì«e½ú¸Ó¦p¦ó¨M¸Ñ?
·P¿E!!!!!!!!!!!!! |
|