Calculate Monthly sum of pieces of every particular employee

[Kartiksvn]

name with sheet 1	pieces	date of work done by employee
a	122	01\01\2022
b	525	01\01\2022
a	436	02\01\2022
c	630	02\01\2022
d	220	01\01\2022
d	400	02\01\2022

in second sheet, there is a lot more data in every month. So, I have to make one formula that calculate each month number of total pieces done by a, b, c, d etc... employees.
Example:

name	Month (jan, feb, march) It can be changeable
a	here I want the formula to get sum of pieces as per month.
b
c
d

 

[OaklandJim]

This may help you. I used sumproduct. The -- means that the value should be treated as a boolean (TRUE or FALSE).

Book1
	C	D	E	F	G	H	I
2		Pieces	Date		Month
3	Adam	122	1/1/2022		1	Adam	122
4	Babu	525	1/1/2022		1	Babu	759
5	Adam	436	2/1/2022		1	Cato	613
6	Cato	344	2/1/2022		1	Devi	220
7	Devi	220	1/1/2022		2	Adam	559
8	Devi	400	2/1/2022		2	Babu	245
9	Cato	389	1/1/2022		2	Cato	905
10	Babu	245	2/1/2022		2	Devi	1021
11	Adam	123	2/15/2022
12	Cato	561	2/15/2022
13	Cato	224	1/15/2022
14	Babu	234	1/15/2022
15	Devi	621	2/16/2022
16
17	Checksums
18	Babu	759	Jan
19	Cato	905	Feb
20	Devi	1021	Feb
Sheet1

Cell Formulas
Range	Formula
I3:I10	I3	=SUMPRODUCT(--(MONTH($E$3:$E$15)=G3),--($C$3:$C$15=H3),$D$3:$D$15)
D18	D18	=SUM(D4+D14)
D19	D19	=SUM(D6,D12)
D20	D20	=SUM(D15,D8)

 

[Kartiksvn]

Thank you so much for your help