+ 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
    76

    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
    Excel 2019
    Posts
    7,062

    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 - RIP 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
    29,464

    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

    RIP - d. 06/10/2022

    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
    76

    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. multiple criteria with countif or sumif
    By Renee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2006, 09:05 AM
  8. 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