How to calculate cumulative values

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

basic question - how to calculate a cumulative percentage? 3
How can I calculate the average of a list of time values in excel 2
hot to calculate peaks of an "irregular" sine wave 1
How do I calculate running pace? 1
HOW DO I COLLECT TEXT DATA FROM A COLUMN 2
Changing formula to a value 1
calculate shipping costs in excel 2007 2
Cut / Copy Paste to F2 Cell for MS Excel 2007 2

Top