COUNTIFS for reocurring Date Entries

[Greenies08]

Hi, I have data where by the row is dates and there are multiple columns underneath with data in.
I wish to count the number of times any entry is not blank for a whole month.

So for Nov, the answer would be 14, Dec would be 17

I used COUNTIFS(A2:A7,"<>""",INDEX(B2:H7,,MATCH(M4,B1:H1,0)),">0")

M4 is whatever month I put in on a separate cell

Thank you in advance

Primary Division	26-Nov	27-Nov	28-Nov	29-Nov	03-Dec	04-Dec	05-Dec
Motorsport		4			4		4
New Business	9	6	13	16	20	50	9
Brewery	16	19		9	12	25	17
General		3	4	6	15	12	4
Equestrian					3	6	7
Motorsport						0	0
General	1	7	0	2	1	9	18

<colgroup><col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;"> <col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;"> <col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" span="3"> <col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" span="3"> <tbody> </tbody>

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Primary Division	26-Nov	27-Nov	28-Nov	29-Nov	03-Dec	04-Dec	05-Dec
2	Motorsport		4			4		4
3	New Business	9	6	13	16	20	50	9
4	Brewery	16	19		9	12	25	17					01/12/2019	17
5	General		3	4	6	15	12	4
6	Equestrian					3	6	7
7	Motorsport						0	0
8	General	1	7	0	2	1	9	18
Sheet2

Cell Formulas
Range	Formula
N4	=SUMPRODUCT((MONTH(B1:H1)=MONTH(M4))*(B2:H8>0))

 

[Greenies08]

You, kind Fluff, are a superstar! Was driving me insane and you've made it so simple. Thanks ever so much.

 

[Greenies08]

sorry did type another query but then sorted myself

 

[Fluff]

You're welcome & thanks for the feedback