Thread: Simple daily expenses forms

Hi,

I would like to create a simple credit/debit form using 5 columns.

e.g:


Date| Purchased Item | Credit | Debit | Total |

The Purchased Item column will have several entries a day. So basically, once I've entered the amounts I would like to see the total at the end be a running one.

I've tried to find out what the necessary formulas are, but with no joy.

Any help again would really be appreciated.

Wiggo

The attached is as basic as it gets.
The total is placed at the top so that it is always in view as more data are added.
Dynamic Named Ranges for Credits and Debits were created and used as the references in the formula for totals.

This will suffice if you are not concerned about specific date ranges, in which case you should use a Pivot Table.

Fantastic

I wasnt expecting anything like that. I really appreciate it.

Thanks again,

Wiggo

Glad to have been of help.

If you are satisfied with your solution please mark the thread as solved and remember to add to the reputation of those who contributed to the solution by clicking on the blue scales icon in the blue bar of the post.