Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    count if formula (2000)

    Good Afternoon All,

    Is there a limitation to the number of ranges you can combine to look of a certain number? Like Countif(a1:a10, a12:a21,a23:a32,100)? I only show 3 ranges here however I have 15 different ranges to look for this number.

    Any and all help is much appreciated
    cvbs

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: count if formula (2000)

    Use this instead:

    =COUNTIF(A1:A10,100)+COUNTIF(A12:A21,100)+...

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: count if formula (2000)

    Thanks Hans,

    Much appreciated
    cvbs

  4. #4
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: count if formula (2000)

    Or, try this one for multiple range :

    =SUM(COUNTIF(INDIRECT({"A1:A10","A12:A21","A23:A32 "}),100))

    Regards
    Bosco

  5. #5
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: count if formula (2000)

    Thanks Bosco..... and welcome to the lounge !!
    later,
    cvbs

Posting Permissions

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