I would like to enter a SUM formula in an Excel spreadsheet use automation. I will not know how many rows are to be summed so I want to enter the formula similar to Excel's AutoSum feature where it automatically finds the starting point of the column and fills in the formaula. Is there a way to do this?

Thanks,
Robert