SOLVED

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)
Solution

@DeepakPrasad 

That could be

=COUNTIFS(Sheet1!$B:$B,$A11,Sheet1!$C:$C,T$4)

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