View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zeepowlee
 
Posts: n/a
Default Macro for column sum

Hi all

I need a macro to add a column its sum, right below the end of the column.
Column length (i.e. # of rows) is variable.

For instance, let's say data is in D1:D50,
I want the column total in cell D51.
If the data was in D1:D15, I would want the sum in D16.


Thanks for help