+ 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: 2019 but still use also older versions
    Posts
    6,623

    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)

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