Macro to count the amount of times a number is listed

[keranali]

Good Day all I have two work sheets, one contains data tab and the other an overview tab with a table to count the amount of times a number is listed per month, and 7 day week, when the month or week 1-4 is inputted. Please see example below:

Data Table

the project M.xlsm
	B	C	D
1	Date	Time	Num
2	2-Jan-23	Morning	33
3	2-Jan-23	Midday	21
4	2-Jan-23	Afternoon	4
5	2-Jan-23	Evening	1
6	3-Jan-23	Morning	2
7	3-Jan-23	Midday	15
8	3-Jan-23	Afternoon	32
9	3-Jan-23	Evening	22
10	4-Jan-23	Morning	27
11	4-Jan-23	Midday	5
12	4-Jan-23	Afternoon	32
13	4-Jan-23	Evening	35
14	5-Jan-23	Morning	18
15	5-Jan-23	Midday	12
16	5-Jan-23	Afternoon	15
17	5-Jan-23	Evening	11
18	6-Jan-23	Morning	19
19	6-Jan-23	Midday	12
20	6-Jan-23	Afternoon	2
21	6-Jan-23	Evening	20
22	7-Jan-23	Morning	36
23	7-Jan-23	Midday	36
Data

Overview tab with the count table:

the project M.xlsm
	M	N	O	P	Q	R
18	Count
19	1	1	13		25
20	2	1	14		26
21	3		15	2	27	1
22	4	1	16		28
23	5	1	17		29
24	6		18	1	30
25	7		19	1	31
26	8		20	1	32	2
27	9		21	1	33	1
28	10		22	1	34
29	11	1	23		35	1
30	12	2	24		36	2
Overview

.


Input Table:

the project M.xlsm
	A	B
1		Input
2
3	Month	Jan
4	Week	1
Overview

Whereby Jan displays the count for January and Feb For February and Week with a zero value displays the complete month, week 1 displays the first week and week 2 the second etc.

 

[Mario_R]

The formulas in the N, P and R columns of the 'Overview' sheet are incorrectly modified: that's your problem.

 

[keranali]

Yes they were thank you so much for helping.