Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Numbers Formula not Working

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

Posted on

Reply

Page content loaded

Mar 13, 2018 4:47 AM in response to ffmwilson In response to ffmwilson

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.

Mar 13, 2018 4:47 AM

Reply Helpful

Mar 13, 2018 1:48 PM in response to ffmwilson In response to ffmwilson

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?

Mar 13, 2018 1:48 PM

Reply Helpful

Mar 14, 2018 8:58 AM in response to Badunit In response to Badunit

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.

Mar 14, 2018 8:58 AM

Reply Helpful

Mar 14, 2018 9:27 AM in response to ffmwilson In response to ffmwilson

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

Mar 14, 2018 9:27 AM

Reply Helpful
User profile for user: ffmwilson

Question: Numbers Formula not Working