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

[µo°Ý] ·s¼WÄæ¦ì¤£¼vÅT¤½¦¡

[µo°Ý] ·s¼WÄæ¦ì¤£¼vÅT¤½¦¡

¤p§Ì·Q½Ð°Ý¤@¤U

ªþ¥óEXCEL¤u§@ªíªºA6-A20 ¬Ò¦³EXCEL ªº SUM¤½¦¡

¤À§O¬OSUM($B6:O6) -  SUM($B20:O20)

¤p§Ì³Ð«Ø¤F¤@­Ó·s¼WÄæ¦ìªº«ö¶s

¨C·í«ö¤F«ö¶s ±q·|±qBÄæ·s¼W¤@Äæ(Äæ¦ì©¹¥k²¾)

¦ý·s¼W¤@Äæ«á ¤½¦¡¤]·|¸òµÛ©¹«á²¾

­ì¥» A6Àx¦s®æ  = SUM($B6:O6)

´N·|Åܦ¨A6Àx¦s®æ  = SUM($C6:P6)

¬ü·s¼W¤@Ä椽¦¡´N·|©¹«á¶]¤@®æ

©Ò¥H·Q½Ð°Ý¤@¤U¦³¤èªk¥i¥H·s¼WÄæ¦ì¦ý¤½¦¡¤£§ïÅܶÜ

½Ð±Ð¤@¤U¤F ÁÂÁÂ>"<

·s¼WMicrosoft Excel ¤u§@ªí.rar (6.43 KB)

ªþ¥ó

WOW

¦^´_ 1# g93353


    = SUM(indirect("R2:R15",0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# g93353

¤£ºÞ´¡¤J´X¦¸BÄæ,AÄæ=BÄæ+OÄæ
  1. Sub Macro1()
  2. [B:B].Insert
  3. [A6:A20].FormulaR1C1 = "= SUM(RC2:RC[14])"
  4. End Sub
½Æ»s¥N½X

TOP

ÁÂÁª©¤j¸ò register313ªº¦^ÂÐ!!!!!
WOW

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD