View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
By-Tor
 
Posts: n/a
Default How can you sum the last 5 columns of data from a range of data

I have a range of data that ranges from a3 to g43. Some of the range is empty
of data but I enter new data daily. So say the data is currently entered
through row 15. Is there a way I can sum just the last 5 rows of entered
data and have it update automatically whenever I add in a new row of data
into the already established range? Hope that is clear enough.