I believe what I'm looking for is a SUMPRODUCT formula that counts the number of times a set of initials appear according to the dates they correspond to in a table. I hope the table helps to explain what I'm getting at. I'd like to have the formula in E2, F3 and G4 to show how many times WG, SR and RB were assigned to the dates 3/1, 3/2 and 3/4, respectively in A2:B7. Thank you!
A B C D E F G H 1 Date Closer WG SR RB NB 2 3/1 WG 3/1 *2* 3 3/2 SR 3/2 *2* 4 3/4 RB 3/4 *2* 5 3/4 RB 6 3/2 SR 7 3/1 WG
Bookmarks