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

¦Û°Ê¿z¿ï¨D¥[Á`?

¦Û°Ê¿z¿ï¨D¥[Á`?

¾Ç©f¤S¨Ó³Â·Ð¤j®a¤F

½Ð«Ó­ô/¬ü¤kª©¥D «Ó­ô/¬ü¤k¾Çªø¸ò¾Ç©j

À°¦£¾Ç©f§¹¦¨

ÁÂÁ¤F

metrostar300.rar (2.75 KB)

À³¸Ó¥[¤@»²§UÄæ¦ì®e©ö¸Ñ¨M
d2=IF(A2="¥X",-C2,IF(A2="¤J",C2,0))¦V¤U½Æ»s
e1=SUBTOTAL(9,D:D)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦hÁ«ӭôª©¥D
«D±`·P°Ê
±z¯u¬O¤Ó±j¤Ó±j¤F
·PÁ±z¨Ã¯¬¶P±z
©¯ºÖ¦n¹B¥Ã»·­°Á{±z¨­¤W

TOP

¥Îdsum()¸Õ¸Õ¬Ý
=DSUM($A$7:$C$78,$C$1,$A$1:$B2)

gong.rar (2.97 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 1# metrostar


¸Õ¸Õ¥t¤@ºØ°µªk
Àx¦s®æ¸m©ób2
«Ø¥ß©w¤@¦WºÙ x=get.cell(17,$b2)
»²§UÄæd2=x ,¦V¤U½Æ»s
e1=SUMPRODUCT((A2:A72="¤J")*(D2:D72>0)*C2:C72)-SUMPRODUCT((A2:A72="¥X")*(D2:D72>0)*C2:C72)
¿z¿ï­pºâ.zip (3.52 KB)
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2010-7-7 13:36 ½s¿è

¼Ó¥D°Ýªº°ÝÃD³£¦³¤@©wªº²`«×¸òÃø«×

¤½¦¡·|½ÆÂø¤@ÂI

¤£ª¾¹D¬O§_¬O³o·N«ä©O ?

E1

=SUMPRODUCT(SUBTOTAL(109,OFFSET(C$1,ROW($2:$100)-1,))*(A$2:A$100={"¤J","¥X"})*{1,-1})
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¬Ý¤F¦nªº¸Ñµª´N²n
µ¹¤j®a©ç©ç¤â
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

µ¹¼Ó¥D«Øij
¦pªG¸ê®Æ¶W¹L1000µ§¥H¤W,±Ä¥Î¦Û°Ê¿z¿ï¬O¦³°ÝÃDªº,
¼Ó¥D¥²¶·¦Ò¼{¼Æ¾Ú®w¨ç¼Æ©Î¬O¼Ï¯Ã¤ÀªRªí¤ñ¸û§´·í
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-7-7 14:05 ½s¿è

¦^´_ 6# zz5151353


    ¨ç¼Æ¯à¥Î¨ì³o¼Ë,¥u¯à»¡¨ØªA
§Ú³o¨§»G¸£¥u¦b¨ú±o²Ä¤@­Ó«DÁôÂíȥ´Âà
©ç¤â.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¼M
´Î¯Å¤F,«D±`ºë±m
·PÁ¼ӤW¦h¦ì«Ó­ôª©¥D¸ò«Ó­ô¾Çªø
¯S§O¬O³o¦ìzz5151353«Ó­ôª©¥D
·P®¦¥[·PÁ±z­Ì
§¹¥þ¥i¥H¹F¨ì
«D±`ªº·P°Ê©O
±z­Ì¯u¬O¤Ó±j¤Ó±j¤F
·PÁ±z­Ì¨Ã¯¬¶P±z­Ì
©¯ºÖ¦n¹B¥Ã»·­°Á{±z­Ì¨­¤W

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD