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

Sum¨ç¼Æ °Ñ¼Æ¤Ó¦h«ç»ò¿ì

Sum¨ç¼Æ °Ñ¼Æ¤Ó¦h«ç»ò¿ì

½Ð±Ð
¨Ï¥ÎSUM¥[Á`¨ç¼Æ®É,­Y=sum(a1,a14,a17,a25,........a1445)
­Y¬A©·¸Ìªº°Ñ¼Æ¤Ó¦h®É,
¨t²Î·|Åã¥Ü"±z¨Ï¥Îªº°Ñ¼Æ¦³»~"
¨º­n«ç»ò­pºâ¥[Á`ªº­È©O¡H
ÁÂÁÂ
~~

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-3-24 14:50 ½s¿è

sumªº°Ñ¼Æ¤ä«ù1~255­Ó,¥´255­Ó°Ñ¼Æ¤w¸g²Ö¦º¤F
¤@©w­nªº¸Ü¨º´N¤À¬q§a,¥[­Ó + ¤À¦¨¨â­ÓSUM

TOP

SUM(number1,number2, ...)
Number1, number2, ...   ¬O±z·Q­n­pºâÁ`©Mªº 1 ¨ì 30 ­Ó¼Æ­È¤Þ¼Æ¡C

sum(a1,a4,....)¦pªG¹L¦h
«Øij=a1+a4+....
¤@¼Ë®ÄªG
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 3# gong


Gong'R

½Ð±Ð
¦pªG°Ñ¼Æªº¦C¼Æ¶¡®æ¤£¤@©w,
¨Ò¦p(a1,a5,a13,a14,a19,a36,a39,a45....a1445)
¦³¨S¦³¬Æ»ò¿ìªk¥i¥H¤ñ¸û§Ö­pºâÁ`©M©O?
~~

TOP

¦^´_ 4# guinevere
±N °Ñ¼Æªº¦C¼Æ¶¡®æ  ©w¸q¦WºÙ
SUM(©w¸q¦WºÙ )  §Y¥i

TOP

°ò¥»¤W¤£«Øij¨ì³B¥h§ä¦a¤è¦X­p
¦p»Ý­na4,a7,a8,a20...µ¥¤£©w¬Û¥[
«Øij¥[¤@ÄæzÄæ
z4=a4,z7=a7,...
§âzÄæ¥[Á`
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¤£¥i¯à=sum(a1,a14,a17,a25,........a1445)
³o»ò¦hªºÀx¦s®æ«ç»ò¥hÂI¿ï¡H
À³§ä¥X¬°¦ó¿ï³o¨ÇÀx¦s®æªº§PÂ_¦¡
¥Îsumif§a¡I

TOP

¤£¥i¯à=sum(a1,a14,a17,a25,........a1445)
³o»ò¦hªºÀx¦s®æ«ç»ò¥hÂI¿ï¡H
À³§ä¥X¬°¦ó¿ï³o¨ÇÀx¦s®æªº§PÂ_¦¡ ...
chin15 µoªí©ó 2011-3-25 21:48



guinevere ¤j¥i¯à¦³¦oªº¦Ò¶q~~
¬JµM¬O³o»òÂø¶Ã¤S¤j¶qªºÁ`©M~~~ª½±µ"+"À³¸Ó´N¥i¥H¤F,¤£»Ý­n¥ÎSUMªü
Jack

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD