Is this a bug in Numbers?
I have recently finished my spreadsheet for personal finance tracking, and have just encountered what may be a bug in numbers.
I have a few sheets in which i collect the relevant data to be used by the appropriate functions.
This is what I have noticed.
In one sheet I have spending categories in column 1, and the relevant months in the top row. I have used the SUMIFS function to total transactions by category and month. I wrote the first row of functions and when I was done I merely copied and pasted the functions into the adjacent rows since they are exactly the same, the only variable being the spending category, which I allowed for.
I have about 10 categories and they all work perfect except for two rows. I find this very unusual since I have copied and pasted the functions, so no room for error, and not only that, all the other rows work perfect - just these two rows don't do the job. Also, it does not give the error sign (the red triangle with the exclamation mark), but the cells simply return the value $0.00. I even re-wrote the functions to try a different method other than and copied version of the function, but I can't get the values to display correctly in the cells.
Anyways, I just thought that if there is someone else that is encountering the same problem it would be nice to know.
Thanks
ST
Macbook Pro, Mac OS X (10.5.8)