hi, i am trying to sumproduct with condition certain range = RC[-1], but it doesnt work, can anyone help me? thanks.
Dim rGSQty, rGSCode, rGSMult As Range
Set rGSQty = Range("E4", "E10")
Set rGSMult = Range("N4", "N10")
Set rGSCode = Range("G4", "G10")
Dim varCell As Range
For Each varCell In GSPosition.Cells
varCell.FormulaR1C1 = Application.WorksheetFunction.SumProduct("rGSCode = RC[-1]", rGSQty, rGSMult)
Next varCell
Dim rGSQty, rGSCode, rGSMult As Range
Set rGSQty = Range("E4", "E10")
Set rGSMult = Range("N4", "N10")
Set rGSCode = Range("G4", "G10")
Dim varCell As Range
For Each varCell In GSPosition.Cells
varCell.FormulaR1C1 = Application.WorksheetFunction.SumProduct("rGSCode = RC[-1]", rGSQty, rGSMult)
Next varCell