Results 1 to 4 of 4

Thread: Count with Multiple Criteria

  1. 12-11-2011, 03:41 PM #1
    candygirl
    candygirl is offline
    Junior Member
    Join Date
    Dec 2011
    Posts
    5
    Rep Power
    0

    Count with Multiple Criteria

    Hi Again Excel Championsm

    I'm stuck on another excel formula.
    I need to count if:
    column A equals "NSW"
    Column B equals "Demolish", "Land", or "Build"
    Column C equals "A" or "B"
    Column D equals "Industrial.

    I have attached an example.

    Thanks in advance.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 12-11-2011, 04:18 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    Try

    =SUM(COUNTIFS(A:A,"NSW",B:B,{"demolish","land","bu ild"},C:C,{"a";"b"},D: D,"industrial"))
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  3. 12-11-2011, 05:47 PM #3
    candygirl
    candygirl is offline
    Junior Member
    Join Date
    Dec 2011
    Posts
    5
    Rep Power
    0
    Thanks Admin,
    Worked perfect!:D
    Reply With Quote Reply With Quote
  4. 12-11-2011, 07:02 PM #4
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    You are welcome !!
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sumif On Multiple Columns Using Multiple Criteria By Passing A Range Of Values
    By Luke M in forum Excel Help
    Replies: 7
    Last Post: 05-15-2013, 02:56 PM
  2. Vlookup with multiple criteria
    By patsir in forum Excel Help
    Replies: 7
    Last Post: 08-27-2012, 11:15 AM
  3. SUMIF With Multiple Criteria In The Same Column Criteria Range
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 08-11-2012, 10:50 PM
  4. SUM with Multiple Criteria
    By candygirl in forum Excel Help
    Replies: 5
    Last Post: 12-11-2011, 03:21 PM
  5. Lookup on Multiple Criteria
    By ramakrishnan in forum Excel Help
    Replies: 4
    Last Post: 09-15-2011, 10:36 PM

Tags for this Thread

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
  •  

Forum Rules