Results 1 to 15 of 15

Array formula to return all steps of cumulative / running total

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    03-16-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    371

    Array formula to return all steps of cumulative / running total

    Hi all,

    I'm scratching my head around an array formula that I'm trying to build. It has to be an array since I need to use it as an input for a function.

    Bascially what I'm looking for is the equivalent of each step of a cumulative / running total but in array form. It's easiest explained with an example so an image and workbook is attached.

    arraycml.PNG

    What I am aiming for is col D "Array Cml" to have an identical output to col C "Cml Sales" using only col B "Sales".

    Can anyone point me in the right direction?

    Thanks
    Attached Files Attached Files
    Design everything to be as simple as possible, but no simpler.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] formula to return the last figure in a running total
    By OAKLEY in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-29-2013, 01:47 PM
  2. Cumulative (Running) Total.
    By dillkeva in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-14-2013, 06:56 AM
  3. Replies: 4
    Last Post: 09-05-2012, 05:25 AM
  4. Help with Formula to return running YTD total based on a date range
    By RubiksCuber in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 06:09 PM
  5. help running/cumulative total
    By rjc_29 in forum Excel General
    Replies: 2
    Last Post: 06-04-2007, 09:27 AM
  6. Formula Needed to Compare Dates and return a running total
    By Cmonroe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2006, 03:55 PM
  7. Subtotal and running/cumulative total!
    By rahul25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2005, 04:10 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