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.
There are no replies.
Numbers Formula not Working
