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
Bookmarks