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

­pºâ«á¦Û°Ê§R°£

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
     If .Count > 1 Or .Item(1) = "" Then Exit Sub
     If Not Intersect(Range("a3:c3"), .Cells) Is Nothing Then
        .Cells(-1, 1) = Val(.Cells(-1, 1)) + Val(.Value)
        .ClearContents
     End If
End With
End Sub

A3:C3 >> A1:C1

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD