Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Countif (only count if data falls within a range)

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    121
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried several iterations and I cannot get it to work. I would like to get a count of how many data items fall within a certain range.

    For instance, I need a count of how many items have a value between 5 and 15.

    Can anyone help?

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 11:17, pzamory wrote:
    I tried several iterations and I cannot get it to work. I would like to get a count of how many data items fall within a certain range.

    For instance, I need a count of how many items have a value between 5 and 15.

    Can anyone help?

    Thanks
    did you try

    http://www.mrexcel.com/board/viewtop...c=7197&forum=2


  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,655
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-03 11:17, pzamory wrote:
    I tried several iterations and I cannot get it to work. I would like to get a count of how many data items fall within a certain range.

    For instance, I need a count of how many items have a value between 5 and 15.

    Can anyone help?

    Thanks
    In E1 enter: 5
    In E2 enter: 15

    When you say between m and n, you need to be specific -- There are 4 possibities:

    >= m AND < n
    > m AND <= n
    > m AND < n [ often called exclusive between ]
    >= m AND <= n [ often called inclusive between ]

    =COUNTIF(A1:A10,">"&E1)-COUNTIF(A1:A10,">="&E2)

    gives you a count based on exclusive between.

    [ This Message was edited by: Aladin Akyurek on 2002-05-03 11:29 ]

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,655
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default



    did you try

    http://www.mrexcel.com/board/viewtop...c=7197&forum=2


    Ian: I didn't realize that it was a repost.

Some videos you may like

User Tag List

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
  •