+ Reply to Thread
Results 1 to 5 of 5

Count by Person how many times Date 1 = Date 2

  1. #1
    Registered User
    Join Date
    01-27-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Count by Person how many times Date 1 = Date 2

    I am working on a report where I need to count how many times a Date field equals another Date field, for each Person. The data set will contain multiple entries per person, and the Dates will not always match or even have an entry.

    I was attempting to use something such as
    =COUNTIFS(A:A,"Person A",B:B,"=" &C:C )

    But this does not work.

    From the example attachment I was expecting a count of 2 entries for Person A, and 1 entry for Person B.

    Any help is appreciated to understand how I should approach this, thanks!

    forum_sample.xlsx
    Last edited by Azlodin; 01-27-2012 at 12:00 PM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,652

    Re: Count by Person how many times Date 1 = Date 2

    Count of person A:
    Please Login or Register  to view this content.
    Quang PT

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Count by Person how many times Date 1 = Date 2

    Try this:

    Change A12 to read only Person A and A13 to read Person B, then

    =SUMPRODUCT(--($A$2:$A$7=A12),--($B$2:$B$7=$C$2:$C$7))

    copied down
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  4. #4
    Registered User
    Join Date
    01-27-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Count by Person how many times Date 1 = Date 2

    Quote Originally Posted by NBVC View Post
    Try this:

    Change A12 to read only Person A and A13 to read Person B, then

    =SUMPRODUCT(--($A$2:$A$7=A12),--($B$2:$B$7=$C$2:$C$7))

    copied down
    This has worked for my needs, thanks!

    Quick (possibly unrelated) question, when should I be utilizing SUMPRODUCT as opposed to COUNTIFS ?

  5. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Count by Person how many times Date 1 = Date 2

    can't compare ranges to corresponding ranges using COUNTIFS/SUMIFS

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1