no it is not it is the cell directly to the left
.Value = Application.SumIf(Range("Vendor",.Offset(, -1), Range("Freight_Cost"))
Open in new window
.Value = Application.SumIf(Vendor,.Offset(, -1), Freight_Cost)
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Take hold of your future.