Thread: rolling sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
IgorM[_2_] IgorM[_2_] is offline
external usenet poster
 
Posts: 41
Default rolling sum

Hi

How can I do the following. I have a spreadsheat with the 12 columns
representing months. If there for instance for one row in May there is value
6 the some that i want to put at the end of row should take that value of 6
and "keep" it for next months so the outcome will be 58. In case in the same
row there is for instance another value of, say 3, in September the
'rolling' sum of that row will be 61. Is there a (one cell) function to that
in Excel.