Sumifs using multiple criteria in a different worksheet

[DHAM1963]

In WA(First Snip) B2 I would like to sum Column G of the second sheet IF on that second sheet Column B = range 01/01/22 to 01/31/22 and Column C = Column A of WA. Using Office 365. Thank you in advance for your help.


WA M

 

[RobP]

Book1
	A	B	C	D	E	F	G	H
1	FY	Date	WA	Area	WAI	PSA	VS
2	2022	01/01/2022	108	ON	122865 - AVP	128970	5
3	2022	01/01/2022	116	ON	122865 - SOUTH	128969	5
4	2022	01/01/2022	102	ON	128970 - PORCUP	122865	5
5	2022	01/01/2022	128	ON	123192 -IN TOWN	128969	3
6	2022	01/01/2022	134	ON	128970 - TIMMIN	128970	3
7	2022	01/01/2022	136	ON	132219 - KAPSK	132219	2
8
Sheet1

Book1
	A	B	C	D	E
1	WA	Jan-22	Jan-23	Jan-24	J23v24
2	102	5			#DIV/O!
3	104				#DIV/O!
4	106				#DIV/O!
5	108				#DIV/O!
6	116				#DIV/O!
7	117				#DIV/O!
8	122				#DIV/O!
9	123				#DIV/O!
10	128				#DIV/O!
11	129				#DIV/O!
12	134				#DIV/O!
13	135				#DIV/O!
Sheet2

Cell Formulas
Range	Formula
B2	B2	=SUMIFS(Sheet1!G2:G7,Sheet1!B2:B7,">="&DATE(2022,1,1),Sheet1!B2:B7,"<="&DATE(2022,1,30),Sheet1!C2:C7,"="&A2)

Does this work for you ?

thanks
Rob