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

Reply
Question marked as Top-ranking reply

Posted on Jan 3, 2020 6:37 AM

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).


SG

Similar questions

1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.