+ Reply to Thread
Results 1 to 2 of 2

Cumulative Sum and Find the target column?

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cumulative Sum and Find the target column?

    hi,

    Let me try and explain what I am trying to do.

    Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Period 7 Period 8 Period 9 Period 10 Period 11 Period 12 Total
    ABC 100 586 750 288 446 474 500 296 666 345 836 718 6005
    Cumulative Sum 100 686 1436 1724 2170 2644 3144 3440 4106 4451 5287 6005



    Target Number 4000
    Which Period? X

    X = is the column in which the sum from Period 1 to Period 12 will fall in.
    So in the above example, X = Period 6

    Is there a formula to get this done in a better way?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,123

    Re: Cumulative Sum and Find the target column?

    It's not very clear how your data is laid out, or which columns/rows you are using, so it would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Pete

+ 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. Target.column for Data Validation would like to target some cells within column
    By iggypop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2017, 12:35 PM
  2. Set a target and find how many names meet that target
    By top_dog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-23-2017, 12:13 AM
  3. Help with a formula to produce a cumulative target
    By kfryar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-18-2014, 05:57 PM
  4. [SOLVED] I need to find all 5 cell combinations in a column that will have a target average I spe
    By Ronjon101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2013, 01:37 PM
  5. [SOLVED] I need to find all 5 cell combinations in a column that will have a target average I want
    By Ronjon101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2013, 09:06 AM
  6. [SOLVED] Need alternate syntax 'Select Case' on Target.Column and Target.Row at the same time.
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2012, 11:19 AM
  7. Find Target Value in column A
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2011, 06:24 PM

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