Private Sub FindTotal()
With Sheets("DT Week 1")
Sheets("SEPTEMBER").Range("L5:L23").Value = _
WorksheetFunction.SumIfs(.Range("B:B"), _
_
.Range("G:G"), "=Fasiuddin Md" & .Range("L5").Value)
End With
End Sub
I am trying this in VBA but returning "0",Please help on this,I am very new to VBA.
I have names and time in DT week 1(sheet name) and result should be appear in SEPTEMBER(Sheet name)
Any help is appreciated,
Thanks in advance,
Ch Nagaraju