View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.