ced0802
01-27-2016, 04:48 AM
Hi everyone,
I would like to know how to link a sumif with a LEFT function.
Here is my attempt, but it is not the right syntax :
stock = Application.WorksheetFunction.SumIf(Left(wkb.Worksheets("Sheet1").Cells(x, 3), 3) = "A95", wkb.Worksheets("Sheet1").Range("J1:J5000"))
Thank you.
I would like to know how to link a sumif with a LEFT function.
Here is my attempt, but it is not the right syntax :
stock = Application.WorksheetFunction.SumIf(Left(wkb.Worksheets("Sheet1").Cells(x, 3), 3) = "A95", wkb.Worksheets("Sheet1").Range("J1:J5000"))
Thank you.