ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   rolling sum (https://www.excelbanter.com/excel-discussion-misc-queries/209258-rolling-sum.html)

IgorM[_2_]

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.



The Code Cage Team[_10_]

rolling sum
 

Igor, i'm having a little trouble understanding what you want, why not
join our forum and make a post where you can upload a workbook that we
could help you with!


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=25961



All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com