+ Reply to Thread
Results 1 to 3 of 3

Cumulative Sum

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    98

    Cumulative Sum

    Hello

    anyone can tell where I went wrong with this code ? I am trying to SUM($D$1:D15) but it is doing SUM($D$1:E15)

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,618

    Re: Cumulative Sum

    RC[-1] says stay in the same row, but move one column to the left. Since the formula is being written to column F, it results in column E.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-12-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: Cumulative Sum

    RC[-3] and it worked !

    Thanks for your help

+ 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. [SOLVED] Cumulative Sum
    By leovilla in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 03:08 PM
  2. [SOLVED] Cumulative End If ?
    By ZuluNation in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-17-2012, 06:31 AM
  3. Cumulative Sum
    By Fraser Clark in forum Excel General
    Replies: 5
    Last Post: 12-31-2008, 12:26 PM
  4. [SOLVED] Cumulative Sum
    By kk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] Cumulative Sum
    By kk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2005, 04:05 AM

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