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
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