+ Reply to Thread
Results 1 to 4 of 4

Countif and sumif with multiple criteria

  1. #1
    Registered User
    Join Date
    01-12-2016
    Location
    New York
    MS-Off Ver
    2015
    Posts
    73

    Countif and sumif with multiple criteria

    I'm looking to countif and sumif with multiple criteria. I would like to count the number of units (D8, based on the floors selected from B10&B12, and all based on the selection from the combo box)

    I have attached my data:

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Countif and sumif with multiple criteria

    For multiple criteria on SUMIF/COUNTIF use SUMIFS/COUNTIFS or SUMPRODUCT
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,872

    Re: Countif and sumif with multiple criteria

    Hi,

    Are B10 & B12 meant to define an inclusive range of floors. i.e. all floors >=B10 BUT <=B12?

    Do you have Excel 2007 or higher since if so you can use COUNTIFS() rather than the singular COUNTIF() function.

    Have you considered using a Pivot Table which is far simpler and much more useful?

    See attached where I've added some formula to the Summary, and also added a Pivot Table with some examples - which will just need extending.
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    01-12-2016
    Location
    New York
    MS-Off Ver
    2015
    Posts
    73

    Re: Countif and sumif with multiple criteria

    Thanks Richard. How would I do the MIN and MAX formulas for my "ranges"?

+ 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] Multiple Criteria SUMIF Using Column as Negative Criteria
    By freybe06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2014, 04:46 PM
  2. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  3. SUMIF, COUNTIF with multiple criteria
    By montreal1775 in forum Excel General
    Replies: 5
    Last Post: 03-05-2010, 12:14 PM
  4. Sumif/Countif using Multiple Criteria
    By blueyz829 in forum Excel General
    Replies: 5
    Last Post: 11-02-2009, 03:25 PM
  5. SUMIF with multiple criteria, one criteria a specific string
    By Weasel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2008, 05:32 PM
  6. Countif or Sumif with multiple criteria
    By Eladamri in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-22-2006, 07:45 AM
  7. [SOLVED] multiple criteria with countif or sumif
    By Renee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2006, 09:05 AM
  8. [SOLVED] Multiple Criteria for COUNTIF and SUMIF
    By nils_odendaal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2005, 04:45 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