Count entries by person by date?

[chadlaw32]

I have a sheet where multiple people add tickets every day I am trying to count the number of entries made by each person on each day Co column I has the person who created the entry and column O has the date, any ideas?

 

[arthurbr]

Why not try a Pivot Table?

 

[chadlaw32]

For what i need a pivot table will not work, which sucks

 

[chadlaw32]

I have it figured out just not happy with the outcome since I must have the second sheet open for the data to populate.

 

[AhoyNC]

I assume you meant second workbook (instead of sheet) must be opened.
If so, you may be able to use SUMPRODUCT which I believe will work with a closed workbook.

See example of SUMPRODCT below. You will need to change ranges to match your data and workbook(s).

Excel Workbook
	C	D	E	F	G	I	N	O
1	Name	Count	Date	1/15/2019		Name		Date
2	N1	2				N1		1/15/2019
3	N2	1				N2		1/15/2019
4	N3	0				N1		1/15/2019
5	N4	1				N4		1/15/2019
6						N2		1/18/2019
7						N3		1/18/2019
8						N4		1/18/2019
9						N3		1/18/2019
Sheet

 

[arthurbr]

For what i need a pivot table will not work, which sucks

And why is that ?

 

[chadlaw32]

Thanks AhoyNC
That worked great!!!

 

[chadlaw32]

For the sheet I am working with I cannot use a pivot table

 

[AhoyNC]

You're welcome. Thanks for the feed back.