+ Reply to Thread
Results 1 to 3 of 3

Countin numbers in numerous ranges and cells

  1. #1
    Valued Forum Contributor sans's Avatar
    Join Date
    10-19-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    546

    Countin numbers in numerous ranges and cells

    Hello,

    I have a range of numbers in C9:I9 and I would like to count if each one of the cells falls between a range or an individual number. For example, if the numbers are

    3-6-18-27-46-48-67

    I would like to count if

    C9 falls between 1-15
    D9 falls between 6-17 or 20 (basically a range from 6-20 but skipping numbers 18 and 19)
    E9 falls between 16-25,or 27 (skipping number 26)
    F9 falls between 27-35, or 38, or 40 (skipping 36,37 and 39)
    G9 falls between 40-53
    H9 falls between 50-64, or 67
    I9 falls between 60-85

    Is there a better or faster solution than using a very long sumproduct formula?

    Thank you,
    Sans

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Countin numbers in numerous ranges and cells

    You can define in sheet2 table with all your possibilities and then use easier formulas or very long ungly sumproduct

  3. #3
    Valued Forum Contributor sans's Avatar
    Join Date
    10-19-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    546

    Re: Countin numbers in numerous ranges and cells

    Thank you for letting me know. I was just curious to know as I have been trying to use other formulas other than a sumproduct one but it didn't get me anywhere.Sans

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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