+ Reply to Thread
Results 1 to 3 of 3

Count multiple criteria

  1. #1
    Registered User
    Join Date
    01-10-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    1

    Count multiple criteria

    Hi all,

    I desperately need to solve this before work tomorrow and it's already early in the morning here!

    I have two columns:

    Column C - Categories (3 in total - R1.0A, R1.0B and R1.0C)
    Column D - Date (format = mm/yyyy)

    I need to be able to count the times a specific category occurs on a specific date.

    I have tried =SUMPRODUCT((C4:C160="R1.0A")*(D4:D160="03/2011"))


    However this does not work. Any suggestions?!

    Thanks very much

  2. #2
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: URGENT - Please help - Count multiple criteria

    Please Login or Register  to view this content.
    this will show how many times R1.0A and 03/2011 match but you may have to format column D to text

  3. #3
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,199

    Re: Count multiple criteria

    Use with TEXT,

    =SUMPRODUCT((C4:C160="R1.0A")*(TEXT(D4:D160,"mm/yyyy")="03/2011"))

    Also please read the forum rules & amend thread title accordingly.. I think you can delete 'Urgent Please Help' part.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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