Hi,
You can create 2 simple worksheets.
1st sheet having columns such as Date, Expense Nature, Expense, Income, then
remarks (if you want). Then keep on entering data.
2nd sheet can have columns such as expense nature, Expense & income column
Then use sumif() formula to find total expense / income
create range names such as expense nature range from b4:b500, expense from
c4:c500 & income from d4:d500
put at c5 =sumif(expense_nature,b5,expense)
put at d5 =sumif(expense_nature,b5,income)
or create a pivot table which is very easy & changable.
