SUMIFS is a supported formula. If it was not, Numbers would have replaced it with the last calculated value when it was imported.
If the result is 0, it is probably something to do with the column of dates or the "May-24" in your formula or both. Typically "May-24" is interpreted by Numbers as the 24th of May of the current year. May 2024, though, would be May 1, 2024.
If the dates in column F do not need to be dates (and assuming they are formatted like May-24), formatting them as text will probably solve the problem. But they will not sort as dates if you sort the table. They will sort alphabetically.
If the dates in column F need to be dates, you'll have to to look at them to see how they imported. Are they May 24 of the current year or are they May 1 of 2024 or what.