+ Reply to Thread
Results 1 to 6 of 6

Count cells below or asbove value of another cell

  1. #1
    Registered User
    Join Date
    06-14-2020
    Location
    Monaco
    MS-Off Ver
    2019
    Posts
    6

    Count cells below or asbove value of another cell

    Hello, when I try to count cells above below the value of another cell, excel does not recognize my function , in fact it returns a false 0. How do I solve that?
    Example: in C10 i write =COUNTIF(A1:A10,">=B10")
    B10 could be 0.50, but i do not want to use the value, rather the reference to a specific cell.
    Last edited by c43; 07-20-2020 at 02:21 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,279

    Re: Count cells below or asbove value of another cell

    If you only want to count cells and your range begins in row 1Perhaps =match(B10,a1:a100,0)-1

  3. #3
    Registered User
    Join Date
    06-14-2020
    Location
    Monaco
    MS-Off Ver
    2019
    Posts
    6

    Re: Count cells below or asbove value of another cell

    Sorry, I am inexperienced in excel and do not understand your example. I want to count the cells in a specific range that are greater/less in value than the value of another cell, instead of a fixed value. I want to do this for many different cells and values, so I need to do the exact same thing as the formula: =COUNTIF(range,">value") , but instead of that value i want to refer to the value of some cell in the worksheet. I hope i describe it properly
    P.S. my range does not start in row 1 and it is not a fixed range

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,279

    Re: Count cells below or asbove value of another cell

    Perhaps =COUNTIF(A1:A10,">="&B10)

  5. #5
    Registered User
    Join Date
    06-14-2020
    Location
    Monaco
    MS-Off Ver
    2019
    Posts
    6

    Re: Count cells below or asbove value of another cell

    Yes, that helped me just fine. Thank you very much and wish you the best

  6. #6
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,279

    Re: Count cells below or asbove value of another cell

    You're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count cells containing Yes if another cell says yes
    By C0sm0s in forum Excel General
    Replies: 10
    Last Post: 07-06-2016, 05:28 AM
  2. Replies: 2
    Last Post: 05-25-2016, 12:46 PM
  3. [SOLVED] How to Count Cells based on another cell
    By jebindavidson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2015, 01:41 AM
  4. [SOLVED] Count cells in row based on cell value, highlight row if wrong number or cells.
    By gutterball in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-11-2014, 04:00 PM
  5. Count cells containing unique text in cell A if cell B equals i.e. 1
    By killi3000 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-14-2014, 09:32 AM
  6. Count one cell and then count 52 cells later...
    By ArnyVee in forum Excel General
    Replies: 6
    Last Post: 03-05-2009, 03:47 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