Hello! I am using Numbers for a simple spreadsheet budget. When I make an entry on the transaction sheet, it is only transferring/calculating some onto the main budget sheet under the "Actual" and "Difference" columns , but not others. I'm using a duplicate of the same sheet template from last month, which worked just fine. Thanks in advance for any insight into the problem!
MacBook Air (2020 or later)
Start by making a duplicate of the document in its current state. (This is old-fashioned advice that considers the possibility you will not otherwise be able to access a backup copy of the file in its current state.)
Working with either the original or the copy:
Check the other cells in the column. If this is the 'Actual' column, all cells should have the same formula as shown above, with A2 changing to match the row containing that copy of the formula.
If C2 does contain the formula, you can use the Fill control, a small yellow circle that appears on the bottom edge of cell C2 when you bring the pointer close to that location) to fill the formula into the rest of the cells in column C to C10.
The same is true of the formulas in column D. D2 contains B2-C2.
This formula is filled down to D10, and is also used in D11
Row 11 is a Footer row, which may prevent the formula being filled into that row. If that's the case, you'll need to click twice on D11 to open the Formula editor, then enter B11-C11 in D11.
Cell B11 should contain the formula SUM(B)
Cell C11 should contsin the formula SUM(C)
Note that these formulas are also present in any document created from the Personal Budget template. Knowing tht, you could create a new document from the template, then either transfer your entered data from the existing document to the new one, OR copy the formulas from the new document, then Paste them into the same cells of your existing document.
Regards,
Barry
Start by making a duplicate of the document in its current state. (This is old-fashioned advice that considers the possibility you will not otherwise be able to access a backup copy of the file in its current state.)
Working with either the original or the copy:
Check the other cells in the column. If this is the 'Actual' column, all cells should have the same formula as shown above, with A2 changing to match the row containing that copy of the formula.
If C2 does contain the formula, you can use the Fill control, a small yellow circle that appears on the bottom edge of cell C2 when you bring the pointer close to that location) to fill the formula into the rest of the cells in column C to C10.
The same is true of the formulas in column D. D2 contains B2-C2.
This formula is filled down to D10, and is also used in D11
Row 11 is a Footer row, which may prevent the formula being filled into that row. If that's the case, you'll need to click twice on D11 to open the Formula editor, then enter B11-C11 in D11.
Cell B11 should contain the formula SUM(B)
Cell C11 should contsin the formula SUM(C)
Note that these formulas are also present in any document created from the Personal Budget template. Knowing tht, you could create a new document from the template, then either transfer your entered data from the existing document to the new one, OR copy the formulas from the new document, then Paste them into the same cells of your existing document.
Regards,
Barry
Take a look at the formulas in the cells that are not receiving the amounts they should. You may find they have been damaged in some way.
You can view the formula by selecting the cell, then examining the contents of the small window at the bottom left of the page.
Example: formula in the selected celll (C2) is shown at the bottom of the screen shot.
regards,
Barry
Rehabilitated Luddite wrote:
How to I fix a damaged cell?
I'd just select a cell in that column that does have a working formula that is updated properly, command-c to copy, select a cell that needs fixing, and command-v to paste. Repeat as necessary.
SG
Thank you Barry! The 3 cells that aren't updating properly are not showing the formula at the bottom of the page. How to I fix a damaged cell?
Post Deleted.
You answered my question while I was posting.
Entire categories are being ignored.
Thank you so much! That solved the problem. I really appreciate you taking the time to respond.
Numbers isn't working
