Trouble inserting SUM function with variables

I am trying to insert a sum function as the last step in a macro im running and cant quite figure out the way I need to set up the function. I am using two variables endoffile and columncounter in the For loop im running.

Baiscally I need to insert the formula in cell (endoffile, columncounter) with =sum((5, columncounter)endoffile-1,columncounter))

If anyone can help me out I would appreciate it.

Thanks

Do you want to put the formula in the cell or the result?

If the formula is going in the same column as the values being summed then

Please Login or Register  to view this content.