Closed Thread
Results 1 to 2 of 2

How to calculate cumulative values

  1. #1
    Learner
    Guest

    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. #2
    Max
    Guest

    Re: 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.


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1