Excel VBA Code corrections Min(SumIf()-SumIf()) [Closed]

-
Dear all,

I have written the following code and before I could move to the next line a message box appeared with the following error;

Compile error
Expected: List separator or )

Cells(eRow, 9).Value = WorksheetFunction.Min(SumIf(Columns(4),ComboBox2.Value,Columns(6))-WorksheetFunction.SumIf(sum(D$1:D).Value,ComboBox2.value,Sum(I$1:I),Columns(5))))
See more