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.