Results 1 to 8 of 8

Count Columns Until Value Reached

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    197

    Count Columns Until Value Reached

    In a retail environment we've got hundreds of products with an established breakeven point for each. I can establish whether one has reached breakeven by summing the row of sales data, but I want to know how quickly each product reaches that point.

    I need a formula to count the columns (months) and return the number once a given product has reached a certain value.

    One issue, is that each product has a different launch date. So I need the formula to ignore blank cells leading up to the product launch.

    In my sample data file attached, I've got four products with their breakeven number listed and several years of sales (by month).

    I've tried a lot of different formulas. A few from this forum came close, but didn't quite give me what I needed. So I'm really hoping you guys can help me here.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count of cells that can be summed before a value is reached or exceeded?
    By Speshul in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-29-2013, 03:35 PM
  2. [SOLVED] Fill down a row count until a new value is reached?
    By TBrun in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-28-2013, 10:37 AM
  3. [SOLVED] Character Count Until a Number is Reached
    By HangMan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-07-2012, 09:48 AM
  4. Delete duplicates after count reached?
    By mpkavanagh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2011, 08:01 PM
  5. Count until certain percentage reached
    By kirby3820 in forum Excel General
    Replies: 2
    Last Post: 02-22-2011, 01:28 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