Hi!

I am trying to adapt my SUMIF vba code introducing another criteria but I cannot manage to do it.

The code I was using and was running okay is:

Please Login or Register  to view this content.
This runs perfect when:

wsTrips.Range("C12:C65536") = wsWeeklyProduction.Cells(12, "H").Value


But I would like to run this with 2 criteria instead, something like:

wsTrips.Range("C12:C65536") = wsWeeklyProduction.Cells(12, "H").Value and wsTrips.Range("H12:H65536") = wsWeeklyProduction.Cells(26, "B")
Then SUM the cells from wsTrips.Range("V12:V65536")


Any help would be much appreciated.

Thankss!

Regards