| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
| How do I add Cumulative values to Stacked Bar chart? | Charts and Charting in Excel | |||
| calculate APR using cumulative interest? | Excel Discussion (Misc queries) | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Linear Mode
