Results 1 to 4 of 4

Count number of cells in range since last number greater than zero

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2015
    Location
    Newcastle upon Tyne, UK
    MS-Off Ver
    2013
    Posts
    3

    Count number of cells in range since last number greater than zero

    Hi.

    I have a row of numbers that contain usages of a product on a rolling 12 month period. I want to count the number of cells (months) since the item was last used.

    For example, I have the following row of data:

    Product XYZ 2 2 2 2 5 0 1 1 0 2 0 0

    The last column represents the previous month. So in this case, last month, there was no usage and the last time it was used was 3 months ago, because there was no usage last month or the month before.

    What formula could be used to return a "3" as the result to show how many months ago as last used?

    Appreciated!
    Last edited by whitfieldcraig; 03-18-2015 at 06:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to count cells after last number greater than 0
    By gogreenpower in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-09-2014, 02:28 AM
  2. Count number of dates in a range by using greater or less than
    By sclasen24 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 01:29 PM
  3. Replies: 6
    Last Post: 02-24-2012, 01:15 PM
  4. How to Count the Number of Cells Greater than Zero in a Filtered List?
    By denise001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-01-2011, 11:33 AM
  5. Replies: 3
    Last Post: 05-19-2010, 04:09 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