+ Reply to Thread
Results 1 to 3 of 3

Struggling to build count/countif/countifs formula with various comparative criteria!

  1. #1
    Registered User
    Join Date
    01-27-2013
    Location
    New Mexico
    MS-Off Ver
    Excel 2010
    Posts
    38

    Struggling to build count/countif/countifs formula with various comparative criteria!

    I have been working on this project for close to a week now. It seemed it would be very easy from the beginning. Anyway, I'm trying to build a formula that will tell me how many sets of cells on another sheet a particular value falls between. I have attached the workbook and on the sheet group map is a more detailed view of what I'm trying to do. This is also where I need to enter the formula.
    Attached Files Attached Files
    Last edited by dropanddrive03; 02-15-2014 at 02:16 AM.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Struggling to build count/countif/countifs formula with various comparative criteria!

    See attached workbook and modified "Availibility Input" sheet layout to facilitate the formula.
    You might have to work boundary formulas to work properly.
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    01-27-2013
    Location
    New Mexico
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Struggling to build count/countif/countifs formula with various comparative criteria!

    Thank you so much! My biggest frustration was that I knew that sumifs should be able to use comparative operators, but everything I tried failed. I never realized I needed to use an ampersand. That's what sent me in the directions of all that other craziness. Thanks again!

+ 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. [SOLVED] Struggling with COUNTIFS formula - help!
    By Joey_997 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2014, 10:54 AM
  2. [SOLVED] Need to use either COUNTIFS or SUMPRODUCT to count rows based on multiple criteria
    By erabinov in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-15-2013, 03:15 PM
  3. [SOLVED] How to build Formula for countif
    By Bill Williams in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2013, 06:16 PM
  4. Replies: 4
    Last Post: 07-20-2012, 07:51 AM
  5. How to count date as a criteria in countifs
    By huntersdad in forum Excel General
    Replies: 7
    Last Post: 03-29-2011, 07:38 AM

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