I opened an Excel spreadsheet in Numbers and the formula in the attached screenshot is unsupported. I have tried different variations of it, but it still won't work. "May-24" refers a cell with that date in F6:F48 and the "1" is a category code in O6:O48. Could anyone suggest the correct Numbers formula for this, please? Thanks.
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.
How to fix unsupported formula
