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

¤£©T©w¦ì¸m³]©w¥[Á`¤½¦¡

¤£©T©w¦ì¸m³]©w¥[Á`¤½¦¡

»Ý­n±N¥k°¼¤Î¤U¤èÁ`­pªº³¡¤À³]©w¬°¤½¦¡¡A¸ê®Æ¶q¤£©T©w¡A½Ð°Ý¥¨¶°­n¦p¦ó¼¶¼g?

Excel°ÝÃD-20210718.rar (11.71 KB)
Adam

¥»©«³Ì«á¥Ñ n7822123 ©ó 2021-7-18 18:57 ½s¿è

¦^´_ 1# adam2010

¸Õ¸Õ~¬õ¦â³¡¤À·|ÀHµÛ§Aªº©T©wÄæ¦Cªº¼Æ¥Ø¦ÓÅܤÆ

Sub Test()
Rn& = [A2].End(4).Row
Cn& = [A2].End(2).Column
Cells(3, Cn).Resize(Rn - 3) = "=Sum(RC[" & 8 - Cn & "]:RC[-1])"
Cells(Rn, "H").Resize(, Cn - 7) = "=Sum(R[" & 3 - Rn & "]C:R[-1]C)"
End Sub
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 1# adam2010

AF3=SUM(H3:AE3)
H23=SUM(H3:H22)

½Ð¸Õ¬Ý¬Ý¡AÁÂÁÂ

TOP

¦^´_ 2# n7822123

·PÁÂÀs­ô¨ó§U¡A´ú¸ÕµL»~¡AÁÂÁ¡I
Adam

TOP

¦^´_ 3# samwang


    ÁÂÁ±zªº¦^ÂÐ
Adam

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD