Counting Names in one column, only IF there is a date entered into another column

[Yorkshire Man]

Hi Guys,

Just joined the forum so I could post a question as I've searched for an answer to this on the net and couldn't find it.

I have a spreadsheet with employee names (Advisors) in one column (H) and when the advisor generates a new client application we put the application date in another column (T).

What I need to be able to do is count the number of applications each advisor has (broken down into each month) and keep count as dates are added.

If tried CountIFS and read some solutions with SUMPRODUCT but not managed to adapt it for my needs and kept getting errors, I know some of the basics with excel but am a bit of a novice (especially compared to you guys).

Any help greatly appreciated.

Thanks

[TABLE="width: 320"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

Would Excel's Pivot Table feature be sufficient?
Assuming the columns between H & T also have data you can create it directly as shown below. If blank columns between then post back for a work-around if you think this might be useful.

Excel Workbook
	H	T	U	V	W	X	Y	Z
1	Advisor	Application Date		Count of Application Date	Month
2	Advisor 7	1/01/2019			Jan	Feb	Mar	Grand Total
3	Advisor 6	5/01/2019		Row Labels
4	Advisor 7	25/01/2019		Advisor 2	1	3		4
5	Advisor 2	25/01/2019		Advisor 4		1		1
6	Advisor 5	31/01/2019		Advisor 5	1		1	2
7	Advisor 2	2/02/2019		Advisor 6	1	1		2
8	Advisor 6	3/02/2019		Advisor 7	2	1		3
9	Advisor 2	20/02/2019		Grand Total	5	6	1	12
10	Advisor 2	21/02/2019
11	Advisor 7	22/02/2019
12	Advisor 4	23/02/2019
13	Advisor 5	5/03/2019
14
Sheet1

 

[Yorkshire Man]

Hi Peter,

Thanks for the reply, yes it might do the trick, mine doesnt display as yours in the picture but it does give me the data so that's great.

I'm struggling to get it to display by month though so i've inserted a timeline, that doesn't show all the months side by side though. Propably just need to hit a button somewhere.

Thanks so much.

 

[Yorkshire Man]

I've managed to hget it into Months, that's great thanks.

 

[Peter_SSs]

I've managed to hget it into Months, that's great thanks.

God news. Thanks for letting us know.