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

[µo°Ý] ½Ð°Ý¦U¦ì¥ý¶i¡A¦hsheet¦p¦ó¦X¨Ö·J¾ã­pºâ

[µo°Ý] ½Ð°Ý¦U¦ì¥ý¶i¡A¦hsheet¦p¦ó¦X¨Ö·J¾ã­pºâ

¦U¦ì¥ý¶i±z­Ì¦n¡G

¤p§Ì³Ìªñ¹J¨ì¤@­Ó°ÝÃD
excelÀÉ®×ùØ­±¦³7­Ósheet
¨C­Ósheet¸Ì­±ªº®æ¦¡§¹¥þ¤@¼Ë
¦ý¬O¸Ì­±¨C¼Ëª««~½s¸¹¦³¦P¦³²§
¨C¦¸­n·J¾ã­pºâ¡A³£±o¥ý§â¥L­Ì·J¾ã¦¨¤@­Ósheet  µM«á¦b¼Ï¯Ã

¤p§Ì­W«ä³\¤[¡A¤£¾å±o¦³¨S¦³¨ä¥Lªº¤èªk¡A¯à°÷§Q¥Î¤@±iÁ`ªí¨Ó­pºâ³o7±isheet¸Ì­±ªº¼Æ¶q

¥ýÁÂÁ¦U¦ì¥ý¶i¤F

52¶g­q³æ¶q¦X¨Ö.zip (188.56 KB)

¦^´_ 1# kakala0513

office 2003
¸ê®Æ/¦X¨Ö·Jºâ

TOP

ÁÂÁÂ¥ý¶i...
·PÁ±z¤SÅý§Ú¾Ç¨ì¤@½Ò!!
·PÁÂ

TOP

½Ð°Ý, ¦X¨Ö¹Bºâªº¥\¯à,¬O§_»P¼Æ­ÓSUM¥[Á`¤èªk¹p¦P©O? ÁÙ¬O¦³¨ä¥¦ªº¥\¯à©O?
¤èªk1. (n­Ósheet)¦X¨Ö¹Bºâªº¥\¯à
¤èªk2. =SUM(Sheet1!A2:A9)+SUM(Sheet32!A2:A9)+SUM(Sheet3!A2:A9)....

TOP

¥»©«³Ì«á¥Ñ oobird ©ó 2012-6-2 09:46 ½s¿è
½Ð°Ý, ¦X¨Ö¹Bºâªº¥\¯à,¬O§_»P¼Æ­ÓSUM¥[Á`¤èªk¹p¦P©O? ÁÙ¬O¦³¨ä¥¦ªº¥\¯à©O?
¤èªk1. (n­Ósheet)¦X¨Ö¹Bºâªº¥\ ...
alex_wu µoªí©ó 2012-6-2 00:00


§¹¥þ¤£¤@¼Ëªº·§©À¡C
¦X¨Ö·Jºâ¥u­nµ¹¥L½d³ò¡A¥¦·|¥h§ä¬Û¦Pªº±ø¥ó¨ÃÂkÃþ¦P®É§@§A­n¨Dªº¹Bºâ¡A¤£¤@©w¬O­pºâ­þ­ÓÀx¦s®æ¡A¤]¤£¤@©w¬O¥[Á`¡C
sum¥u¬O¬Û¥[ªº¨ç¼Æ¡A¥s¥L¥[¨º¸Ì´N¥[¨º¸Ì¡C

TOP

¦X¨Ö.rar (65.03 KB)
§Ú§âsheet1»Psheet2§ï¦¨¤@¼Ëªº¸ê®Æ.
¥i¬O«ö¤F¦X¨Ö¹Bºâ,¥¦¦n¹³¨S¦³°Ê吔.
(¦³¤W¶Çªþ¥ó)
¥i¥H±Ð¤@¤U¦p¦ó¨Ï¥Î¶Ü?

TOP

a.gif

TOP

sheet2!f2
=SUM(Sheet1:Sheet2!A2)
¤]¤£¿ù¥Î¥i¥H°Ñ¦Ò¬Ý¬Ý
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦X¨Ö.rar (1.83 KB)
1.§Ú¥Î¤F¦X¨Ö¹Bºâ¥\¯à,¥L·|§â¸ê®Æ¦X¨Ö¹Bºâ.
  ¦ý¬O§Ú­×§ï¨Ó·½¸ê®Æ,«o¤£·|³s°Ê.(¤v¤W¶Çªþ¥ó)
2.½Ð°Ý¤£·|³s°Ê¬O¥¿±`ªº¶Ü?
3.­Y¤£·|³s°Ê¬O¥¿±`ªº,¨º½Ð°Ý¨º¦X¨Ö¹Bºâ¦³¤°»ò¦n³B©O?
  ©Î¬O¥i¥H¥Î¦b¤°»ò±¡ªp©O?

TOP

¦^´_ 9# alex_wu

1.´«¤u§@ªí(¤£¥Î¨Ó·½¤u§@ªísheet1,sheet2)«Ø¥ß¦X¨Ö·Jºâ
2.¤Ä¿ï »P¨Ó·½¸ê®Æ³sµ²

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD