Summation across of a variable amount of columns VBA formula

I'm trying to enter the summation formula into three
columns that vary in placement based on the value of num_objs. Basically, the number of grey columns in each of the three sets will equal num_objs. I want the user to be able to enter values into the grey columns in the middle section and the values of the two rightmost white columns (with '0's in them currently) will change accordingly.

My current code is below. However, I keep getting a compile error saying "Expected: end of statement".

I've been searching for a solution online for a couple days now, and I don't see how my code is different than what I've been seeing of other people using variables in their formulas.

Please Login or Register  to view this content.

Thanks for all your help.

Sometimes Excel will insert the spaces for you when you're using variables inside a FormulaR1C1 syntax, othertimes you just have to do it yourself.

Please Login or Register  to view this content.