Where did I go wrong? I have the same formula set up across the board but there is a few in the deposit Column that are still showing $0.00 and one in the expenses column. Not sure why it worked in one place but not the others? Second picture is where the $ isn't showing up correctly.
<Image Edited by Host to Remove Personal Information>
MacBook Air, iOS 11.2.6
Two thoughts:
1) If any of the cells in the columns with numbers are formatted as text instead of as currency, they will not be included in the sum. Select the entire column(s) and format as currency just to be sure none are text.
2) If the text is even slightly different (other than case), it won't be included in the sum. Copy/paste one of the cells of text to your deposit or expenses sheet rather than trying to type them in the same. That way you will know for sure they are the same.
In general, I recommend using a pop up menu cell type for your categories so that you are 100% sure there are no spelling differences or double spaces or whatever. You can select all the categories in your register table and change the format to pop up. It will not change the values of any of your existing entries but will change all those cells to pop up menus. You can then use that pop up menu in your new rows and copy/paste it into your other tables.
Two thoughts:
1) If any of the cells in the columns with numbers are formatted as text instead of as currency, they will not be included in the sum. Select the entire column(s) and format as currency just to be sure none are text.
2) If the text is even slightly different (other than case), it won't be included in the sum. Copy/paste one of the cells of text to your deposit or expenses sheet rather than trying to type them in the same. That way you will know for sure they are the same.
In general, I recommend using a pop up menu cell type for your categories so that you are 100% sure there are no spelling differences or double spaces or whatever. You can select all the categories in your register table and change the format to pop up. It will not change the values of any of your existing entries but will change all those cells to pop up menus. You can then use that pop up menu in your new rows and copy/paste it into your other tables.
Your screenshot shows the formula in that one cell that is not summing correctly. I assume it is referring to the table in your other screenshot. I notice it is referring to columns F and D of that table but, unless you have a hidden column to the left of the table, the data you want is in columns E (category) and C (expenses). Are you sure the formulas are the same for all rows?
I am positive they are all the same. The same exact formula is used in the rows above and below the one I have highlighted but is also a problem in the table above it too. There is a hidden column there but that is hidden for a purpose and used for another formula set up by Barry (the other person that replied here) for summing cost by date.
Something to try:
Select cell Budget::Expenses::B7, displaying "E-6 Bond insurance PTO Treasurer"
Copy.
In the row of Register:: Account 169476 Register dated February 12 2018, select the cell in column F (?) displaying "E-6 Bond insurance PTO Treasurer"
Paste.
Any change?
Regards,
Barry
I would suspect a difference between this label in column B and the one it is to match in .
Possibly a stray space.
Regards,
Barry
I have checked and rechecked. I have Even re-wrote the formula in those spaces with no luck. I think I’ll give it fresh eyes in the morning.
Already did all that too.
Oh and they are already pop up menus too. This is so frustrating. Which means it has to be something simple.
If there is nothing sensitive in the file, I will take a look at it if you email it to me. Click on my username to get my email addr.
I have Numbers 4.3.1
Numbers Formula not Working
