How to correct my combined SumIf and SumProduct calculation in macro coding

I get a type mismatch error on the following code line. I have no idea what this offset and Address is doing in this code so maybe you could explain. I do not fully understand what you are doing.

v = v + .Parent.Evaluate("SUMPRODUCT(" & .Offset(,7).Address & "," & .Offset(,1).Address & ")")

I attached my spreadsheet logic. Look at the following method where I am trying to modify the code:

Private Sub CalcYTDSummary()