+ Reply to Thread
Results 1 to 3 of 3

Adding data of cells in one column and creating the additions in another

  1. #1
    Registered User
    Join Date
    12-02-2007
    Posts
    5

    Question Adding data of cells in one column and creating the additions in another

    Let me explain what I am trying to achieve and I would totally appreicate any help:

    I have a column with, say, these numbers: a1: 1 a2: 3 a3: 4.5 a4: 9

    I want to be able to create a parallel column where I will have: b1 : 1 b2: 4 b3: 8.5 b4: 17.5

    note that the second column is just adding numbers of all the prev. cells of column a: a1, then a1+a2, a1+a2+a3 etc.

    Hope my question is clear!

    Thank you so much,

    Dana Berliner

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    Put this in B1 and copy down:

    =SUM($A$1:A1)

  3. #3
    Registered User
    Join Date
    12-02-2007
    Posts
    5
    I pasted the formula in "special" and it worked!

    Thank you so much
    ,

    Dana Berliner
    Last edited by dberliner; 12-03-2007 at 10:16 AM.

+ Reply to 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