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

[µo°Ý] ¥i§_¥u¥[Á`³æ¼Æ¦Cªº¼Æ¶q¡H

[µo°Ý] ¥i§_¥u¥[Á`³æ¼Æ¦Cªº¼Æ¶q¡H

¥»©«³Ì«á¥Ñ bvge ©ó 2011-2-12 10:23 ½s¿è

¦pªG¦³¤@¤d¦C¥H¤W...
§Ú¥u­n¥[Á`A3,A5,A7,A9,A11,.........A1001,A1003,A1005¦C

½Ð¬Ýªþ¥ó·|¤ñ¸û²M·¡
·|ªº«e½ú½Ð«ü¾É
·PÁ¡I



¦³·j¯Á¹L...
­Y¦³­«½Æ½Ðª©¥D§R°£


VIP.rar (7.35 KB)

d97=SUMIF($A$3:$A$94,">0",$D$3:$D$94)
d99=SUMIF($A$3:$A$94,"",$D$3:$D$94)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

«z ¼F®`³á¡I
¸Õ¹L¥i¥H¤F¡A·PÁÂ gong ¬Û§U
ÁÂÁ¡I

TOP

³oÃöÁä¥D­n¦b©ó ">0" ©M " "

¨º¦pªG©T©w¸õ2¦C¥[Á`¡A¨Ò¦pA1,A4,A7,A9........A1000.A1003,A1006,A1009
©Î¬O©T©w¸õ5¦C¥[Á`¡A¨Ò¦pA1,A6,A11,A16........A1001.A1006,A1011,A1016

³o¤½¦¡¤£ª¾­n¦pªG¤U¡H

TOP

=SUMPRODUCT((MOD(ROW($D$3:$D$94),3)=0)*$D$3:$D$94)
¥[Á`²Ä3,6,9,12,15.....¦C

TOP

ÁÂÁ oobird «ü¾É¡A¨ü¯q¨}¦h¡I

TOP

d97=SUMIF($A$3A$94,">0",$D$3D$94)
d99=SUMIF($A$3A$94,"",$D$3D$94)
gong µoªí©ó 2011-2-12 12:37



·Q½Ð°Ý gong ª©¤j
³æ¼Æ¦C¥Î ">0"
Âù¼Æ¦C¥Î " "
">0" ©M " " ¬O¦ó·N?¦p¦ó¸ÑÄÀ?
ÁÂÁ¡I

TOP

¦^´_ 7# bvge


    ¥ÑAÄ檺­È°µ§PÂ_·Ç«h¡A¦Ó§AAÄ泡¥÷¬O¦³¦X¨ÖÀx¦s®æ
©Ò¥H¬Ý¨£ªº­È¬O³Q°O¿ý¦b¦X¨ÖÀx¦s®æªº²Ä¤@­ÓÀx¦s®æ¦ì¸m
²Ä¤G­ÓÀx¦s®æªº­È¬OªÅ­È
©Ò¥HªÅ­È¬O¥HÂù¤Þ¸¹ªí¥Ü
¦Ó>0´N¬O¦³¥¿¼Æ¼Æ­È¦s¦bªº¦ì¸m
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁ Hsieh ¶Wª©¸ÔºÉ¸Ñ»¡
¨ü±Ð¤F¡AÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD