Looking for a help with excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2418615%22%20slang%3D%22en-US%22%3ELooking%20for%20a%20help%20with%20excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2418615%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20master%20data%20(SHEET%201)%20consists%20of%20a%20set%20of%20names%20in%20one%20of%20the%20columns%20and%20another%20column%20has%20the%20date%20when%20a%20particular%20ticket%20was%20assigned%20to.%20In%20another%20(SHEET%202)%2C%20I%20have%20those%20names%20in%20the%20first%20column%2C%20while%20I%20have%20dates%20on%20first%20row.%3CBR%20%2F%3EI%20need%20a%20formula%20to%20compute%20the%20number%20of%20tickets%20assigned%20to%20that%20individuals%20based%20on%20the%20dates%20as%20the%20output%20in%20SHEET%202.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2418615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2418631%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20a%20help%20with%20excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2418631%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1071738%22%20target%3D%22_blank%22%3E%40DeepakPrasad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIFS(Sheet1!%24B%3A%24B%2C%24A11%2CSheet1!%24C%3A%24C%2CT%244)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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

@DeepakPrasad 

That could be

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

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