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
 


      

Kirim email ke