![]() ![]() Under the “Summary” section, add this formula to the “Total income” field =SUMIF(Database!B2:B18,"Income",Database!C2:C18)Īdd the below formula to the “Total Expenses” field =SUMIF(Database!B2:B18,"Expense",Database!C2:C18)Īnd finally add this formula to “Balance” section to display the Balance amount =N9-N13Īs our database is empty, all fields will be Empty. One is for adding Income, second is for adding expense and one for clearing the database. Also create a “Summary” section to show total income, total expense and the balance amount. On “Entry” sheet, create separate fields for the entry of “Income” and entry of “Expense”. Sheet “Database” will act as the back-end i.e., database of our tool. Sheet “Entry” will be the front-end of our tool. Rename the Sheet1 as “Entry” and rename the Sheet2 as “Database”. Open a new workbook and save it as macro enabled excel file. Otherwise, if you want to DIY, you can read the contents below. If you want to start to use the software as soon as possible, then you can: Now you can log and track all your incomes, expenses and keep a track of your balances. ![]() This article will help you to create simple and easy to use Expense manager. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |