ªð¦^¦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 : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD