Regarding Sumifs and dates

[Jootin]

Currently, I'm having a problem with sumifs when capturing data with dates as a criteria. my sheet are using mm/dd/yy format for the dates and I need to get them by month, regardless of the day. any other workaround without using pivot tables?

[#2]

@Jootin 

Use a pivot table.

Or create the criteria like this for August 2024:

date_field;">=08/01/24"

date_field;"<=08/31/24"

[#3]

@Jootin There are multiple ways, though it depends upon what you mean by "by month".  See the attached workbook.

For example, you can use a helper column (two alternatives are shown).  Or you can use a FILTER function to subset the data, and SUM the results.