How to use countifs to count the number times a specific course was sold based on vertical and horizontal criteria?

[Waffles255]

Good Morning Guys, could you please assist me with the following i would like count the number of times that a specific course was sold in March, April etc so i have a vertical criteria and horizontal, could you please assist with guidance of how i will be able to accomplish this? I have Office 365. Thanks in advance

MRExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21			Date	COURSE
2	AB															01/03/2020	TR
3	*****															01/03/2020	TR
4	ALL															01/03/2020	WP
5	ARH															02/03/2020	WP
6	BB															02/03/2020	FGL1
7	EQ															02/03/2020	FGL1
8	FGL1															02/03/2020	BB
9	KEQ															02/03/2020	KSG
10	KSG															02/03/2020	KSG
11	FG THEORY															02/03/2020	FGL1
12	PRACTICAL															02/03/2020	PFG
13	PFG															02/03/2020	PFG
14	SG															02/03/2020	PFG
15	TG															02/03/2020	PFG
16	TR															02/03/2020	PFG
17	WP															02/03/2020	ALL
18	WTS															02/03/2020	FGL1
19	#N/A															02/03/2020	FGL1
Summary

 

[AlanY]

try this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21			Date	COURSE
2	AB	0	0	0	0	0	0	0	0	0	0	0	0			01/03/2020	TR
3	*****	18	0	0	0	0	0	0	0	0	0	0	1			01/03/2020	TR
4	ALL	1	0	0	0	0	0	0	0	0	0	0	0			01/03/2020	WP
5	ARH	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	WP
6	BB	1	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	FGL1
7	EQ	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	FGL1
8	FGL1	5	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	BB
9	KEQ	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	KSG
10	KSG	2	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	KSG
11	FG THEORY	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	FGL1
12	PRACTICAL	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	PFG
13	PFG	5	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	PFG
14	SG	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	PFG
15	TG	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	PFG
16	TR	2	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	PFG
17	WP	2	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	ALL
18	WTS	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	FGL1
19	#N/A	0	0	0	0	0	0	0	0	0	0	0	0			02/03/2020	FGL1
20																03/02/2021	FGL2
Sheet1

Cell Formulas
Range	Formula
B2:M19	B2	=COUNTIFS($Q:$Q,$A2,$P:$P,">"&EOMONTH(B$1,-1),$P:$P,"<="&EOMONTH(B$1,0))

 

[Waffles255]

Sir you are a legend looks perfect thanks!!!!

 

[AlanY]

you're welcome