Create Monthly Report With Unstructured Data

[Sufiyan97]

I have Data in Below Format

Recruitment_Report_Oct_2021 Practice.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1							19/10/2021	19/10/2021	19/10/2021	19/10/2021	20/10/2021	20/10/2021	20/10/2021	20/10/2021
2	Prority	Manager	Name of The Position	Status	Working At Profile	Package	Openings	Interviewed	Offered	Joined	Openings	Interviewed	Offered	Joined
3
4	2	Name1	Associate/Sr. Associate	Live	Name1		18	2	0	0	18	1	0	0
5	2	Name2	Associate/Sr. Associate	Live	Name2		14	0	0	0	14	1	0	0
6	1	Name3	Semi Qualified CA	Live	Name3		67	0	0	0	67	0	0	0
7	2	Name4	Finance & Account Manager	Closed	Name4		1	0	0	0	1	0	0	0
8	1	Name5	Semi Qualified CA	Live	Name5		75	0	0	0	75	0	0	0
9	2	Name6	Team Leader (UK)	Live	Name6		1	0	0	0	1	0	0	0
10	2	Name7	Associate/Sr. Associate(UK)	Live	Name7		3	0	0	0	3	0	0	0
11	1	Name8	Manager (UK)	Live	Name8
12	1	Name9	Associate (Baroda)	Live	Name9		38	0	0	0	38	1	0	0
13	1	Name10	CA Inter(Baroda)	Closed	Name10		1	0	0	0	1	0	0	0
14	1	Name11	CA	Live	Name11		13	0	0	0	13	0	0	0
15	1	Name12	CA	Live	Name12		14	0	0	0	14	0	0	0
16	2	Name13	Trainee	Live	Name13		150	0	0	0	150	5	0	0
17	1	Name14	Trainee	Live	Name14			0	0	0	5	0	1	0
18	Total						395	2	0	0	400	8	1	0
Final Entigirity-CS-Technic (2)

Cells with Data Validation
Cell	Allow	Criteria
D2:D17	List	Live,Closed,Pending,Hold,Offered,NR

I want to create a monthly report based on above Data like I just enter month name and get the total for entire month for the example here are tow dates 19 and 20 October so what I want is get total for both the dates,

Recruitment_Report_Oct_2021 Practice.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1							October	October	October	October
2	Prority	Manager	Name of The Position	Status	Working At Profile	Package	Openings	Interviewed	Offered	Joined
3
4	2	Name1	Associate/Sr. Associate	Live	Name1		36	3	0	0
5	2	Name2	Associate/Sr. Associate	Live	Name2		28	1	0	0
6	1	Name3	Semi Qualified CA	Live	Name3		134	0	0	0
7	2	Name4	Finance & Account Manager	Closed	Name4		2	0	0	0
8	1	Name5	Semi Qualified CA	Live	Name5		150	0	0	0
9	2	Name6	Team Leader (UK)	Live	Name6		2	0	0	0
10	2	Name7	Associate/Sr. Associate(UK)	Live	Name7		6	0	0	0
11	1	Name8	Manager (UK)	Live	Name8		0	0	0	0
12	1	Name9	Associate (Baroda)	Live	Name9		76	1	0	0
13	1	Name10	CA Inter(Baroda)	Closed	Name10		2	0	0	0
14	1	Name11	CA	Live	Name11		26	0	0	0
15	1	Name12	CA	Live	Name12		28	0	0	0
16	2	Name13	Trainee	Live	Name13		300	5	0	0
17	1	Name14	Trainee	Live	Name14		5	0	1	0
18	Total						795	10	1	0
19
Sheet2

Cell Formulas
Range	Formula
G4:J17	G4	='Final Entigirity-CS-Technic (2)'!G4+'Final Entigirity-CS-Technic (2)'!K4
G18:J18	G18	=SUM(G4:G17)

Cells with Data Validation
Cell	Allow	Criteria
D2:D17	List	Live,Closed,Pending,Hold,Offered,NR

 

[bebo021999]

Try:

=SUMIFS('Final Entigirity-CS-Technic (2)'!$G4:$N4,'Final Entigirity-CS-Technic (2)'!$G$1:$N$1,">="&DATEVALUE("1"&G$1),'Final Entigirity-CS-Technic (2)'!$G$1:$N$1,"<="&EOMONTH(DATEVALUE("1"&G$1),0),'Final Entigirity-CS-Technic (2)'!$G$2:$N$2,G$2)

 

[Sufiyan97]

Thank you @bebo021999

It works Perfect.