Forum Discussion
VBA sumif code
Hi All,
please help with macro that will look for the same value in column and then sum value from another column.
ex.
| id | qyt | sum |
| 1111111 | 14 | |
| 2222222 | 56 | |
| 3333333 | 534 | |
| 1111111 | 23 | |
| 2222222 | 43 | |
| 3333333 | 4 |
thank you in advance 🙂
best regards
michal
3 Replies
- Is there some reason this needs to be done in VBA? Either an actual SUMIF function or a PivotTable would be much, much easier and more reliable.
For next purpose it need to be done in VBA, but i think that i found the easiest way:
Option Explicit
Sub CreateUniqueList()
Dim lastrow As Longlastrow = Cells(Rows.Count, "B").End(xlUp).Row
ActiveSheet.Range("B2:B" & lastrow).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=ActiveSheet.Range("D2"), _
Unique:=True
End Sub- my mistake :D:D this one:
Sub sumifFunction()
Range(“G2”) = “A”
Range(“H2”) = Application.WorksheetFunction.SumIf(Range(“A2:B8”), “A”, Range(“B2:B8”))
End Sub
