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

[µo°Ý] ¦p¦ó¥ÎEXCEL¨ç¼Æ°µ¶µ¥Ø¤p­p?

[µo°Ý] ¦p¦ó¥ÎEXCEL¨ç¼Æ°µ¶µ¥Ø¤p­p?

¥»©«³Ì«á¥Ñ la1975 ©ó 2014-1-2 14:39 ½s¿è

¦p¦ó¥ÎEXCEL¨ç¼Æ°µ¶µ¥Ø¤p­p?
ÃD¥Ø¦p
½Ð°Ý­n¥ÎEXCEL¨ç¼Æºâ¥X¦UÃþ¥N¸¹(1 2 3 4)ªºª÷ÃB¤p­pÄæ¦ì

PS...¤£­n¥ÎEXCEL¤ºÁä¿ï³æ¸Ì­±ªº¤p­p¥\¯à...¨ç¼Æ¤½¦¡«ç»ò¼g¡H!!!!


¥N¸¹ ª÷ÃB »Ý¤p­pÄæ¦ì(ª÷ÃB¤p­p)
1,,,,,,,10,
1,,,,,,, 0,
1,,,,,,,,5,,,,,,,,,,,,,,15
2,,,,,,,,3,
2,,,,,,, 4,,,,,,,,,,,,,,, 7
3,,,,,,, 2,,,,,,,,,,,,,,, 2
4,,,,,,, 0,,,,,,,,,,,,,,, 0

­ì©l¸ê®Æ¦p¤U,¦@¤W¸Uµ§,§Æ±æ§ä¥Xµ²ºâ¤½¦¡
½s¸¹...................ª÷ÃB...................µ²ºâ
201000072,,,,,,172,027,,,,,,,,,,,,,,,,,,
201000072,,,,,,19,945,,,,,,,,,,,,,,,191,972
201100054,,,,,,176,438,,,,,,,,,,,,,176,438
201100073,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
201100073,,,,,,113,425,,,,,,,,,,,,,,,113,425

¥»©«³Ì«á¥Ñ p212 ©ó 2014-1-2 17:16 ½s¿è

¦^´_ 1# la1975
½Ð°Ý¡u½s¸¹¡v¸ê®Æ¬°³sÄò©Ê©Î«D³sÄò©Ê¡H¡]¥H1#ªº´y­z¨Ó¬Ý¡A¡u½s¸¹¡v¸ê®Æ¬°³sÄò©Ê¡C¡^
¥i¥H¤W¶Ç½d¨ÒÀÉ¡H¥i¬Ù¥h¤j¹Ù¨à³yÀɧxÂZ¡A¤è«K¬ã¨s¡AÁÂÁ¡I

TOP

C2 =IF(A2<>A3,SUM(B$1:B2)-SUM(C$1:C1),"")

¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

C3=IF(A2=A3,"",SUMPRODUCT((A$2:A2=A2)*(B$2:B2)))

OR =IF(COUNTIF(A$2:A2,A2)=COUNTIF(A:A,A2),SUMPRODUCT((A$2:A$19=A2)*B$2:B$19),"")
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 1# la1975

     ¬O³o­Ó·N«ä¶Ü? ÁÙ¬O­n¦³½d¨Ò¤ñ¸û¦n ^^
    1233.gif
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 4# softsadwind


  ¶â  §Ú¸Õ¸Õ ÁÂÁÂÀ°¦£¡I

TOP

¦^´_ 3# ML089


    ÁÂÁ§A  ·P®¦¡I

TOP

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