+ Reply to Thread
Results 1 to 3 of 3

Counting number of days it takes to reach desired value

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2010
    Posts
    57

    Counting number of days it takes to reach desired value

    Hello,

    I've been working with some spreadsheets but I can't figure out how to do this one formula I need. I'm trying to count how many cells (Blank & Non Blank) it takes until a certain value is reached. In this case I'm trying to count how many days it takes to reach 80% or the first value above 80%. But I dont want any value to be returned unless the data set has reached 80% because I am updating the spreadsheet daily and some of the entries have not reached 80% yet, but they eventually will as time goes bye. I was trying to use a countif function but I'm not really sure what to use. All of the data for the function is in one row.

    Thank you for the help, it would be much appreciated!

    Rob

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Counting number of days it takes to reach desired value

    perhaps a sample worksheet alongwith desired results will provide better insight
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    07-05-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Counting number of days it takes to reach desired value

    Okay so I'm trying to get row "G" based on the data to the right
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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