Results 1 to 8 of 8

Counting Values Until Number Reached, Then Returning Cells Counted

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2019
    Location
    New York
    MS-Off Ver
    2010
    Posts
    4

    Counting Values Until Number Reached, Then Returning Cells Counted

    Hello,

    I have been unable to locate, or maybe understand, how to construct a function such as this. I have a total list of quantities for items in column "A," and columns from "C" to "S" that count out projected items per day on a day-by-day basis. I would like Excel to start counting from left to right and see how many days it will take to reach the "Ordered Quantity" "A" by adding up the values inside those items-per-day columns. Returning the number of cells it needed to count to get that total value would be fine. Please see the attached document/screenshot for clarification; note that I have already filled in the "Days Worth" column partially manually to demonstrate what I am looking for, and also note that some of the values are rounded, which is why they might seem off (for example row 1 seems like it should be 9 days because of partial quantities). Thank you in advance!

    -ExtraLarge

    Capture.JPG
    Attached Files Attached Files
    Last edited by ExtraLarge; 10-07-2019 at 09:38 AM. Reason: Clarity and additional uploads

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 12-12-2018, 12:34 AM
  2. COUNTIF where number of cells to be counted varies
    By nicandthat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-27-2017, 04:45 PM
  3. [SOLVED] Counting no. cells in range until first max./min. value is reached
    By zeegerman in forum Excel General
    Replies: 7
    Last Post: 11-30-2016, 11:02 AM
  4. [SOLVED] Counting number of 1s in a row until blank cell is reached.
    By wjhansen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2013, 08:00 AM
  5. Counting Values Contiguously but duplicates counted as 1
    By akwishestofish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2013, 10:22 AM
  6. Replies: 2
    Last Post: 06-23-2009, 05:38 PM
  7. [SOLVED] Counting blank cells until value is reached
    By Dan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-01-2006, 09:00 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