Thread: Rolling running total by date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O[_2_] Dave O[_2_] is offline
external usenet poster
  
Posts: 19
Default Rolling running total by date
Starting in cell B28, this formula will drag down for subsequent days
and sum the desired range on a rolling basis:
=SUM(OFFSET(A28,-27,0,1,1):A28)

Reply With QuoteReply With Quote