Looking for a help with excel Formula

New Contributor

My master data (SHEET 1) consists of a set of names in one of the columns and another column has the date when a particular ticket was assigned to. In another (SHEET 2), I have those names in the first column, while I have dates on first row.
I need a formula to compute the number of tickets assigned to that individuals based on the dates as the output in SHEET 2.

2 Replies
best response confirmed by allyreckerman (Microsoft)


That could be


@Sergei Baklan Thanks a lot. That worked...