Q: Numbers 3 has bugs in calculations.

Gerd,

Would you mind sharing with us what the error was?

Jerry

Gerd,

When you come back we can answer any questions you have on finding and using the old version. Hint - look in Applications, iWork.

Jerry

Hi Gerd,

I found the same Bug in a Spreadsheet I use. German System . It. Happens in a  formula where monthnames are compared.

Has anyone Fund this too?

Reiner

Hi Gerd,

I opened the document and here is what I get. As you can see, it doesn't seem to be a Numbers bug.

I see you have the data format for the first row of the Jährliches Budget nach Monaten table set to Automatic and the format for the Monat column as a pop-up. You could try changing the data format for the first row of the Jährliches Budget nach Monaten table to a pop-up (and add the same pop-up list as you have in the yada table) and see if that helps.

Or maybe it's related somehow to your Language & Region preferences (System Preferences>Language & Region>Advanced>Dates.... Mine are like this and it's possible Numbers 3 is too fussy about what it expects.

SG

When I change the Format language to German the spreadsheet still works here.

SG

On other thought. Numbers seems to be a little *too* smart about guessing whether you mean a date or not. For example if you type Jan into a cell on your system it will probably convert that to a date and show Januar. It probably is taking the text values from the Pop-up and converting those to dates too. To avoid unwanted conversion to a date try typing an apostrophe (single quote or ') in front of it and it will show just Jan and not convert to a date. (Jerry posted that trick in another thread).

So here you could format both row 1 of the Jährliches Budget nach Monaten table and column Monat of the yada table as Text and type the month names in with a ' in front of each.  That way the SUMIF formula should find an exact match.  This, of course, becomes a problem if you have more than one Januar (i.e. more than one year in your budget). But for one year it should work.

SG

Hi Gerd,

Right. I see the pop-up here too. What I'm thinking is that under the hood Numbers 3 may be converting the text from the Pop-up choice you make into a date, just as if you had typed it in.  So a possible workaround is to not use dates at all just the month names as text. That should work if you have only one year.

SG

Another quick thing to try is retyping the months up top and re-choosing the month in each pop-up.

Maybe they didn't import correctly (if this was a document you used before in Numbers '09)

SG

Now that you've got it working in English, if you switch back to German again, does it still work?

SG