Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    COUNTIF (EXCEL2000)

    I know this is simple but somehow I cannot get it right. How does one use the COUNTIF function to count for values when the criteria in not one value but a range ie COUNTIF the value of X is higher than Zero but less than and equla to six.

    thanks in advance
    Novicexcelite

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COUNTIF (EXCEL2000)

    You might do something like this:

    <pre>=COUNTIF(A1:A40,">0")-COUNTIF(A1:A40,">6")
    </pre>

    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: COUNTIF (EXCEL2000)

    Legare,
    Thanks a lot.
    Novice

Posting Permissions

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