+ Reply to Thread
Results 1 to 2 of 2

Cumulative sum over different columns

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    MS Office 2016
    Posts
    1

    Cumulative sum over different columns

    Dear excel-users,

    For my thesis I have to calculate the cumulative returns over multiple days. For now I have the returns already but have to sum them up cumulative per column. See below some returns out my spreadsheet. Only the letters should add cumulative, like a1+a2 etc. Since I have 61 rows, and 717 columns I am looking for a formula I can copy down and to the right. Cause sum($a$1:a1) does not hold for the other columns..

    a b c d e
    1 0,84% 0,06% -0,08% -0,47% -0,30%
    2 3,47% 1,62% -0,32% -0,90% -3,38%
    3 -0,41% 0,20% -0,95% 0,15% 1,78%
    4 6,37% 0,02% 0,79% 0,23% -0,46%
    5 3,32% 0,02% -0,46% 1,05% -0,77%
    6 1,49% -1,58% -2,21% 0,76% -3,20%
    7 -0,09% -0,46% -0,63% 1,00% -0,33%
    8 -3,13% 0,20% -1,71% 0,40% -0,37%

    Thank you!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Cumulative sum over different columns

    Have you tried also
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ?
    note mixed addressing used in a$1
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Separate 4 columns of data into 2 cumulative bars
    By mavaspa in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-30-2016, 03:36 AM
  2. [SOLVED] Help in Cumulative Sum
    By ropbasuel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2016, 08:36 PM
  3. Formulas for cumulative value and cumulative %
    By Brotein in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2013, 07:19 PM
  4. Replies: 13
    Last Post: 02-22-2013, 06:41 AM
  5. Top cumulative %
    By sttrader in forum Excel General
    Replies: 7
    Last Post: 12-18-2011, 03:07 PM
  6. Replies: 10
    Last Post: 10-23-2008, 09:50 PM
  7. [SOLVED] Charting: Displaying cumulative totals at top of stacked columns
    By Jean in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-14-2006, 09:35 AM

Tags for this Thread

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