Previously working SUMIFS functions that call values from "Pop-Up Menu" cells not working

I have established that previously working SUMIFS functions are not working after a Numbers update, in particular when they are calling values from a Pop-Up Menu cell. Anyone else noticing this?

So, for example I have:

SUMIFS(Total, Category,"=Groceries",Month,"=January")

I am totalling the amount of money spent on groceries in January.

For the sake of simplicity: when the cell format is "text" and reads "January," the equation works. When I have the 12 months of the year listed in a pop-up menu, the function returns zero. (It does not fail, it returns zero.).

Same goes for Groceries. When Groceries is a value in a pop-up menu, the function returns zero. When I strip the cell of the menu and change it to text, the function works.

Any help would be appreciated. I know how finnicky this app can be with typos; I'm sure everything is typed correctly.

Posted on Jan 1, 2020 8:31 PM

1 reply

SGIII

Level 8 (38,224 points)

Jan 3, 2020 6:37 AM in response to Phaedon2

In my tests it appears that Numbers automatically interprets month names in Pop-Up Menu as date-time, which won't match Text in SUMIFS.

I suggest just entering the month names directly (having first formatted the cells as Text).