How to calculate cumulative values
Dear all, I am having a very long excel coloumn where I have to do
cummulative additions, I am doing it manually by copy and paste but have to add always the first cell, which is time consuming, Can any one please tell me some automated function or macro to calculate cummulative values in Microscoft Excel worksheet. Thanks ahead. |
How to calculate cumulative values
An example ..
Assuming the source values are running in A2 down, Put in B2: =SUM($A$2:A2) Copy B2 down as far as required, to cumulate the source values -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Learner" wrote: Dear all, I am having a very long excel coloumn where I have to do cummulative additions, I am doing it manually by copy and paste but have to add always the first cell, which is time consuming, Can any one please tell me some automated function or macro to calculate cummulative values in Microscoft Excel worksheet. Thanks ahead. |
All times are GMT +1. The time now is 01:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com