ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to calculate cumulative values (https://www.excelbanter.com/excel-worksheet-functions/104442-how-calculate-cumulative-values.html)

Learner

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.

Max

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