PDA

View Full Version : [SOLVED] SUMIF with Left criteria VBA



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.

mancubus
01-27-2016, 07:16 AM
SumIf(CriteriaRange, Criteria, SumRange)



With wkb.Worksheets("Sheet1")
stock = Application.SumIf(.Range("C1:C5000"), "A95*", .Range("J1:J5000"))
End With

ced0802
01-27-2016, 08:44 AM
Perfect !! Thank you so much for your help !

mancubus
01-27-2016, 12:38 PM
you are welcome. thanks for the feed back.