I have vba code to Sumif lookup name.
It is working for one criteria, how to modify for multiple criteria"
Code:
Sub SumDiscountsByOrderDate()
Dim sumRange As Range
Dim criteriaRange As Range
Dim criteria As String
Set sumRange = Range("F2:F11")
Set criteriaRange = Range("B2:B11")
criteria = Range("I4").Value
Range("J4") = WorksheetFunction.SumIfs(sumRange, criteriaRange, criteria)
End Sub
It is working for one criteria, how to modify for multiple criteria"
Code:
Sub SumDiscountsByOrderDate()
Dim sumRange As Range
Dim criteriaRange As Range
Dim criteria As String
Set sumRange = Range("F2:F11")
Set criteriaRange = Range("B2:B11")
criteria = Range("I4").Value
Range("J4") = WorksheetFunction.SumIfs(sumRange, criteriaRange, criteria)
End Sub