For something like summing a column, I’d normally just type “=Sum(A2:A8905).” Only issue is I’m trying to convert someone’s old code into something new, and I’m unsure of how to write the formulas for dynamic ranges. A8905 won’t always be 8905 for further clarification.