ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Summing last row in list (https://www.excelbanter.com/excel-programming/282281-summing-last-row-list.html)

ed

Summing last row in list
 
Hi

How would I add a sum formula to the last row with data in
it for column C

Thanks for your help.

Trevor Shuttleworth

Summing last row in list
 
Ed

Range("C65536").End(xlUp).Offset(1, 0).FormulaR1C1 = _
"=SUM(R2C:R[-1]C)"

Regards

Trevor


"Ed" wrote in message
...
Hi

How would I add a sum formula to the last row with data in
it for column C

Thanks for your help.





All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com