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

[TABLE="width: 345"]
<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>[TR]
[TD="width: 109, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] "]Primary Division[/TD]
[TD="width: 51, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]26-Nov[/TD]
[TD="width: 51, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]27-Nov[/TD]
[TD="width: 51, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]28-Nov[/TD]
[TD="width: 51, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]29-Nov[/TD]
[TD="width: 49, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]03-Dec[/TD]
[TD="width: 49, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]04-Dec[/TD]
[TD="width: 49, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFC000]#FFC000[/URL] , align: right"]05-Dec[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Motorsport[/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]New Business[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent, align: right"]13[/TD]
[TD="bgcolor: transparent, align: right"]16[/TD]
[TD="bgcolor: transparent, align: right"]20[/TD]
[TD="bgcolor: transparent, align: right"]50[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Brewery[/TD]
[TD="bgcolor: transparent, align: right"]16[/TD]
[TD="bgcolor: transparent, align: right"]19[/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent, align: right"]12[/TD]
[TD="bgcolor: transparent, align: right"]25[/TD]
[TD="bgcolor: transparent, align: right"]17[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]General[/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[TD="bgcolor: transparent, align: right"]12[/TD]
[TD="bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Equestrian[/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]6[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Motorsport[/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: #A6A6A6"] [/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]General[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]7[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]9[/TD]
[TD="bgcolor: transparent, align: right"]18[/TD]
[/TR]
</tbody>[/TABLE]

 

[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