calculating a cell

[luxbax12]

Hi,
When i add a new dollar amount in the same cell everyday,
is there a way for another cell to keep adding those totals?

Thanks.

example:

A1- 51.00


A5 51.00

Next day

A1-60.00

A5 111.00

 

[luxbax12]

worked perfect.
thanks for all the help.

 

[Oaktree]

I really, really advise against this approach of over-riding cells. Why not just list out your daily expenses in a column (adding new expenses to the bottom of the list) and sum by month (using a pivot table or sumif or whatever your method of choice is)?

As an example, say you put in $225. Then, in the next entry, you put in $100. But, you decide that the item before should be reversed out. Did you put in $255? Or $225? "Shoot, I can't remember!"

Or, "did I put in both of these $225 receipts before I got my phone call and interrupted my train of thought?" Stuff like that will be so much easier if all of the items are (transparently) listed instead of just being able to see the last adjustment and the total.

 

[luxbax12]

I will also have to add a yearly total also, which if i add a daily value to
each cell, i will end up printing a lot of pages.

 

[Oaktree]

You don't have to *print* all of the detail. You can create a summary by month or by year or whatever as necessary.

But, as the raw data, I'd really recommend keeping each item as its own entry. Adding descriptions with each dollar amount would help you down the line as well.

 

[luxbax12]

THANKS I'LL GIVE THAT A SHOT ALSO.