Formula has stopped working halfway through workbook

[raider4b]

i am using the below formula to calculate data over 2 sheets which has worked fine on the first 3 sheets but has now stopped

This is one that has worked- =SUM(SUMIFS(July!D:D,July!G:G,"MT CC",July!B:B,"<=44752"),SUMIFS(D:D,G:G,"MT CC",B:B,">=44723"))

This is one that hasn't - =SUM(SUMIFS(August!D:D,August!G:G,"MT CC",August!B:B,"<=44783"),SUMIFS(D:D,G:G,"MT CC",B:B,">=44753"))

I can't figure out why

 

[Fluff]

Hi & welcome to MrExcel.
Can you post some sample data that shows the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Also please explain exactly what isn't working.

 

[ExceLoki]

they appear to be functioning as written. please provide some more information as to what the problem you are experiencing is.
-----------

Book1
	A	B	C	D	E	F	G
1	11	7/1/2022		5			mt cc
2	23	7/1/2022		9			mt cc
Sheet1

Cell Formulas
Range	Formula
A1	A1	=SUM(SUMIFS(August!D:D,August!G:G,"MT CC",August!B:B,"<=44783"),SUMIFS(D:D,G:G,"MT CC",B:B,">=44753"))
A2	A2	=SUM(SUMIFS(July!D:D,July!G:G,"MT CC",July!B:B,"<=44752"),SUMIFS(D:D,G:G,"MT CC",B:B,">=44723"))

-----------

Book1
	A	B	C	D	E	F	G
1		7/10/2022		1			MT CC
2		7/10/2022		2			MT CC
3		7/10/2022		1			MT CC
4		7/10/2022		2			MT CC
5		7/10/2022		1			MT CC
6		7/10/2022		2			MT CC
July

-----------

Book1
	A	B	C	D	E	F	G
1		8/10/2022		1			MT CC
2		8/10/2022		2			MT CC
3		8/10/2022		3			MT CC
4		8/10/2022		4
5		8/10/2022		5			MT CC
6		8/10/2022		6
August