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

[µo°Ý] ½Ð¦p ³oºØ²Ö¥[ªk­n«ç¼g©O?

[µo°Ý] ½Ð¦p ³oºØ²Ö¥[ªk­n«ç¼g©O?

¥»©«³Ì«á¥Ñ icestormer ©ó 2013-8-19 15:26 ½s¿è

http://imgur.com/WcckVXQ

¦p¹Ï

­ì¥»¥u­n¥Îsum ¨Ó²Ö¥[(A2:A22)´N¦n¤F

¦ý¬O ½d³ò¤j¤p¤£¤@ ¯à¤£¯à¼g¤@­Ó¤½¦¡Åý¥¦¦Û°Ê¨Ì·Ó½d³òÅÜ°Ê(¥Ñ¤W©¹¤U²Ö¥[) ¥[Á`  ¦Ó¤£¥Î¦b½d³ò¦³©ÒÅÜ°Ê®É,ÁÙ­n¥Î¤â°Ê¥h§ïsum(A2:AXXX)??

·PÁÂ~~

¦^´_ 1# icestormer
¬Ý¤£¬O«ÜÀ´¡A¥i¥H¼ÒÀÀ¤@¤U§A·Q­nªºµ²ªG¶Ü¡H
¬O­n1,3,6,10...
ÁÙ¬O21,41,60...(¥Ñ¤U¨ì¤W)
A¦æ¼Æ¦r³£¬O¥Ñ1¨ìn¡AÁÙ¬O·|ÅÜ¡H

TOP

¦^´_ 1# icestormer

¦b¥ô¤@Àx­È®æ¶K¤W¡G

=SUM(OFFSET(A1,1,0,COUNT(A:A),1))

³o¼ËÀ³¸Ó¨S°ÝÃD¡A¦bAÄæ¤@ª½©¹¤U¿é¤J¼Æ¦r¡A¤]¯à°÷«ùÄòªº¥[Á`¶i¥h¡C

TOP

¦^´_ 3# owen06


  ¹ï¤£°_ §Ú»¡ªº¤£°÷©ú¥Õ §Ú­«§Ë¤@¦¸^^
  <<³o¬O¶}©l¥[Á`¤§«e




<<³o¬O §Æ±æ§¹¦¨ªº¹Ï¥Ü(­«ÂI¬O¦U¼Æ¾Ú¤§¶¡³£¬O¤À¶} ²Ö¥[ªº)

·PÁÂÀ°¦£~~

TOP

¦^´_ 4# icestormer


  C2=SUM(A2:A$99)-SUM(C3:C$99)

½Æ»sC2¨ìC17
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089


   ·PÁ  ¤£¹L³o¤£¦X§Ú­ì¥»·Q¥Îªº¤è¦¡©O

¦pªG³£©w¥X©T©w½d³ò §Úª½±µ ¥ÎSUM()  ¤â°Ê©Ô½d³ò´N¦æ¤F»¡   ~

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD