+ Reply to Thread
Results 1 to 2 of 2

Count multiple criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    06-25-2009
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    Count multiple criteria

    Hi all,

    here is the sample data, on which i want to count the record based of specefic criteria

    Cname Product Model Mfg Year
    ABC PQR MNO 2003
    ABC STU MNO 2004
    XYZ PQR MNO 2005
    XYZ STU MNO 2006
    ABC STU IJK 2007
    XYZ PQR IJK 2008
    ABC PQR IJK 2009
    XYZ PQR IJK 2010
    ABC PQR IJK 2011
    XYZ STU IJK 2012


    Count of records where Cname = ABC,Product = PQR,Model = IJK and Mfg Year is > 2005

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Count multiple criteria

    Traditional solution pre XL2007 would be SUMPRODUCT, eg:

    =SUMPRODUCT(--($A$1:$A$100="ABC"),--($B$1:$B$100="PQR"),--($C$1:$C$100="IJK"),--($D$1:$D$100>2005))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1