I trying to create a worksheet where I enter a new number into a cell at different times and have a running total in another cell.
Cells cannot reference themselves.
One cell can refernece another and add 1 (or any arbitrary value). Can provide any more detail regarding your problem?
Hi Wayne,
I am trying to create a running total of an expense. As I enter a receipt into a cell each day just to register the expense amount I want it to keep a running total in another cell. I don't need to enter a separate line item for each receipt, just record the total. Hope this helps.
Thanks!
You can use two tables:
1) to enter your receipts (called "Receipts")
2) to summarize the receipts (called "Summary")
The formula for the summary is:
=SUM(Receipt Amount)
The summary is a separate table and can reside where you like relative to the receipt table.
Here's what the two tables look like when you do not show the table names:
JJ,
What you are asking for is called recursion. It doesn't work in a spreadsheet environment.
The closest you can come is to add the new value to the first empty cell in a column of previous entries, then have Numbers display the last entry in the column, which would be the new one, is some location of your choice. The running total would be the sum of the entry column, easy.
Jerry
Thanks Wayne,
I will give it a try and see if it will work.
Have a great night!
Jon
Hi Jerry,
Thanks for the tip. I will give this a try as well.
Have a great night!
Jon
JJHorn wrote:
Hi Jerry,
Thanks for the tip. I will give this a try as well.
Have a great night!
Jon
Jon,
Here's a graphic on my suggestion:
The expression in Display :: A2 is =OFFSET(Enter Here :: $A$1,COUNT(Enter Here :: A), 0)
The expression in Display :: B2 is =SUM(Enter Here :: A)
Regards,
Jerry
What is the formula for a cell equal to itself plus another cell?
