I have a number of formulas in Column AZ like this:
I'd like to have the option of using VBA to produce the same results. When I run this code below, I get all zeroes. Is there a way to make this work?
Dim cel As Range
For Each cel In Range("AZ6:AZ10")
Dim str As String
str = cel.Offset(0, -4).Address
cel = Application.WorksheetFunction.SumIf([AllConfigs], str, [AllJ])