UDF berikut ini menjumlahkan value yang ada pada kolom ganjil:
Function SumKolomGanjil(r As Range) As Double
'anton suryadi 19/Mar/2010
Dim c As Range
Dim x As Double
For Each c In r
If c.column Mod 2 Then
x = c + x
End If
Next c
sumKolomGanjil = x
End Function
Penggunaan: =SumKolomGanjil(A1:E1)
>semoga bermanfaat
________________________________
From: hery wahyudi <[email protected]>
To: [email protected]
Sent: Thu, March 18, 2010 2:03:12 PM
Subject: Re: [belajar-excel] Sum lompat
Private Function sumlompat(r As Range, l As Integer)
Dim t As Long
If l <= 1 Then
For i = 1 To r.Cells.Count
t = t + r.Cells(i)
Next i
Else
For i = 1 To Round(((r.Cells. Count) / l), 0)
t = t + r.Cells((i * l) - (l - 1))
Next i
End If
sumlompat = t
End Function
Bener kata Bu Guru, gak lebih keren
Miturut Gultom kados ingkang kaserat ing ngandap meniko:
>
>Dear All,
>
>Dulu pernah ada VBA yang membuat sum per 2
>column or 2 baris
>Kalau tidak keberatan minta yah?
>
>Regards,
>
>Gultom
>
--
Template
SalamHangat dan Jabat Erat,
Hery Wahyudi