Sumif function issue

[mrsushi]

Cant seem to correct the code to work.

On sheet "Monthly", i have the below imputed.

Basically trying to sum up totals from sheet "DailyStats". So based on 2 criteria, i need the loaded totals (column B), but only for those in January dates (Column A).

Any ideas where the formula is going wrong please?

Regards
M

SUMIFS(DailyStats!R:R, DailyStats!B:B, "Loaded", DailyStats!A:A, ">=01/01/2024", DailyStats!A:A, "<=01/31/2024")

 

[Fluff]

Maybe

SUMIFS(DailyStats!R:R, DailyStats!B:B, "Loaded", DailyStats!A:A, ">=01/01/2024", DailyStats!A:A, "<=31/01/2024")

 

[mrsushi]

Maybe

SUMIFS(DailyStats!R:R, DailyStats!B:B, "Loaded", DailyStats!A:A, ">=01/01/2024", DailyStats!A:A, "<=31/01/2024")

Thats worked.

Thank you very much.
Regards
M

 

[Fluff]

You're welcome & thanks for the feedback.