Results 1 to 3 of 3

Thread: Right to left counting cells with value until the first empty cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2014
    Posts
    123
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Right to left counting cells with value until the first empty cell

    I'm looking to count from right to left counting the number of cells with a value until the first empty cell. All cells are formulas. The range is set D:Y. I need to count cells that are greater than 0 until it reaches an empty cell. Can someone help me out with this ?

  2. #2
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    22,648
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Right to left counting cells with value until the first empty cell

    It sounds like "consider the cells between column Y and the first empty cell to the left of that, what number of those cells contain a value > 0"

    If that is the question then
    =COUNTIF(INDEX(1:1,1,MAX(IF(A1:Y1="",COLUMN(A1:Y1)))):Y1, ">0")
    entered with Ctrl-Shift-Enter should do what you want.

  3. #3
    Board Regular
    Join Date
    Feb 2014
    Posts
    123
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Right to left counting cells with value until the first empty cell

    My date range is D4:Y4. I have a list of names in column A and a id number in column b. Column C has no value and their days they worked start in column D to Y. I am working backwards from current date to make sure their count of days worked does not exceed 13 straight. I tried the above formula and I am getting a value error. All the cells are populated with a sumif formula on a table if that makes any difference to the formula above.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •