Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ed ed is offline
external usenet poster
 
Posts: 59
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,089
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
summing data from a list bfont Excel Discussion (Misc queries) 2 September 13th 09 09:07 PM
SUMMING UP ONLY ONES IN A LIST FARAZ QURESHI Excel Discussion (Misc queries) 1 April 21st 09 06:35 AM
Summing a filtered list Neil Excel Discussion (Misc queries) 4 September 21st 07 07:40 PM
Summing List entries Zoltan Excel Discussion (Misc queries) 9 March 13th 07 01:19 AM
Summing List Entries 2 Zoltan Excel Discussion (Misc queries) 1 March 5th 07 02:14 AM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"