Hi, I would like ask you to one multiple loop with if. I have to sum with two criteria. First is ID and second is date. I prepare this vba code but doesn't work:
a,b,dd are range where are items to sum or range of criteria.
I are rows with ID
Z are rows with date
if ID (name) is same in two table then is necessary have to same date and then make sum for these ID.
For i = 14 To finalrow
For z = 3 To 9
If ws_target.Cells(i, 1) > " " Then
ws_target.Cells(i10) = Application.WorksheetFunction.SumIfs(ws_source.range(b), ws_source.range(a), ws_target.Cells(i, 1), ws_source(dd), ws_target.Cells(z, 4))
next z
end if
next I
could you please help me?
Bookmarks