Somehow this works
But this does not:
Anythign wrong in the syntax??
THanks
Code:
Sheets("Commissions").Range("A65536").End(xlUp).Offset(0, 1).Value = Application.WorksheetFunction.SumProduct((CommissionRng), (CommissionRng))
But this does not:
Code:
Sheets("Commissions").Range("A65536").End(xlUp).Offset(0, 1).Value = Application.WorksheetFunction.SumProduct((CommissionRng>50), (CommissionRng))
--> Here i sum only the Commissions > 50...
Anythign wrong in the syntax??
THanks