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

EXCEL¥[Á`

EXCEL¥[Á`

¥»©«³Ì«á¥Ñ cdkee ©ó 2010-10-4 18:11 ½s¿è

½Ð±Ð¤j¤j¡A±NCELL(A3:A100)¨C­Ó­È¸òCELL(A1)¬Û´î«á§@¥[Á`¡AEXCEL ©M EXCEL VBAÀ³¸Ó«ç¼Ë¼g?ÁÂÁÂ!

=SUMPRODUCT((A3:A100-A1)*1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    «Ü¦n¥Î!·PÁª©¤jÀ°¦£!!!

TOP

¥»©«³Ì«á¥Ñ cdkee ©ó 2010-10-4 19:49 ½s¿è
=SUMPRODUCT((A3:A100-A1)*1)
Hsieh µoªí©ó 2010-10-4 18:18



    ¹ï¤£°_!¤£¬O¬Û­¼¡AÀ³¸Ó¬O¦U¼Æ­È¬Û´îA1«á¥[Á`¤~¬O¡C¬O§_=SUMX2MY2()?¦AÁÂÁª©¤j!

TOP

¦^´_ 4# cdkee
§A¦³Åçºâ¬Ý¬Ý¶Ü?

   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  cdkee
§A¦³Åçºâ¬Ý¬Ý¶Ü?
Hsieh µoªí©ó 2010-10-4 19:56



    ·Fªº¤Ó²Ö¤F¡A¬O¤p½ú²´ªá!!ÁÂÁª©¤j¦A«ü±Ð!

TOP

={SUM((A3:A100-A1)}
joviwang

TOP

=sum(a3:a100)-a1*count(a3:a100)
ÁÙ¬O
=sum(a3:a100)-a1*98
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD