Match criteria in Column A and count amount of remaining cells below
Results 1 to 5 of 5

Thread: Match criteria in Column A and count amount of remaining cells below

  1. #1
    New Member
    Join Date
    May 2018
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Match criteria in Column A and count amount of remaining cells below

    Hello,

    I would like to match and find a criteria in column A from C1 cell, and then calculate how many cells has values below with including the found one.
    By looking at the table below it should return count of 4.
    Much appreciate your help.

    A B C D
    1 Current Week 29
    2 Week Data 1 Data 2 Data 3
    3 24 1 1 1
    4 25 2 2 2
    5 26 3 3 3
    6 27 4 4 4
    7 28 5 5 5
    8 29 6 6 6
    9 30 7 7 7
    10 31 8 8 8
    11 32 9 9 9
    Last edited by Addictions; Jul 20th, 2019 at 01:11 PM.

  2. #2
    Board Regular navic's Avatar
    Join Date
    Jun 2015
    Location
    Europa - Croatia
    Posts
    201
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Match criteria in Column A and count amount of remaining cells below

    try
    Code:
    =COUNTIF(A3:A11,">="&C1)

  3. #3
    New Member
    Join Date
    May 2018
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Match criteria in Column A and count amount of remaining cells below

    Please ignore I found the way of doing it:

    =COUNTIF($A$3:$A$11,">="&C1)
    Last edited by Addictions; Jul 20th, 2019 at 01:15 PM.

  4. #4
    New Member
    Join Date
    May 2018
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Match criteria in Column A and count amount of remaining cells below

    Quote Originally Posted by navic View Post
    try
    Code:
    =COUNTIF(A3:A11,">="&C1)
    Thank you. I had a read through your explanations and figured it out that way
    Really much appreciate your help !

  5. #5
    Board Regular navic's Avatar
    Join Date
    Jun 2015
    Location
    Europa - Croatia
    Posts
    201
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Match criteria in Column A and count amount of remaining cells below

    Okay, never mind.
    You're welcome.

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
  •