Looking for a help with excel Formula

[DeepakPrasad]

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 · Accepted solution]

@DeepakPrasad 

That could be

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

[#3]

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