var olasın ustam
malatyalı, 31-01-2010 tarihinden beri AccessTr.neT üyesidir.
Sub getir()
Dim son As Long
agitutarý.Value = ""
If cocuk.Value = Empty Or medenihal.Value = Empty Then Exit Sub
With sh
son = .Cells(Rows.Count, "C").End(3).Row
If son < 2 Then Exit Sub
agitutarý.Value = Evaluate("SUMPRODUCT((" & .Name & "!C2:C" & son & "=""" & medenihal.Value & """)" & _
"*(" & .Name & "!D2" & son & "=" & Val(cocuk.Value) & ")" & _
"*(" & .Name & "!E2:E" & son & "))")
End With
End Sub