Sumifs Function on mac wont work

Question

Sumifs Function on mac wont work

i've been dealing with this problem for so long now. somehow i feel like my SUMIFS formula is already correct but the function return 0. Can someone please tell me what is it i'm doing wrong.

i did this based on the youtube video by macmostvideo titled building a basic business spreadsheet in mac numbers. this spreadsheet if for my monthly expenses.

MacBook Air 13″, macOS 11.4

Posted on Jul 30, 2021 12:08 AM

Reply

Answer 1

Jul 30, 2021 4:06 AM in response to Badunit

Thank you so much. I’ve done what you’ve told but somehow it still didn’t do anything. Then, i did the same thing to the year on table 2, changed it to text and now it works like magic. Thank you so much!!! You have no idea how much you’ve helped me. I wish that you go thru your life with ease and prosperity.

Reply

Answer 2

Badunit

Level 7

30,342 points

Jul 30, 2021 2:47 AM in response to coffeemaker29

Try reformatting cell Table 2::A2 to text.

You might consider the same thing for Table 1:A2. It does not play a role in your formula but I assume it is used for something.

Looking at your tables,

Expense Log::Month has the months aligned to the left of the cell. This leads me to believe they are text.
Table 2::A has the months aligned to the right. This leads me to believe they are date&time values with only the month being displayed.
Table 1 doesn't seem to be doing anything here but it also has the month aligned to the right of the cell

The text "June" is not equal to the date "June 1, 2021" so it is finding no matching values for your SUMIFS.

If you type "June" into a cell that has not been pre-formatted as text, it will be turned into June 1 of the current year. If you look at the cell format it will be "automatic" but will also have settings for the date and time. If you format the cell as text before typing "June" it will stay as "June".

Reply

Sumifs Function on mac wont work

Similar questions