(1) Calculate total expense of each month: In Cell B16 enter =SUM(B10:B15), and drag the Fill Handle to apply this formula to Range C16:M16.
Step 3: Calculate the total expense of every month and every items. (3) Calculate the total income in the budget year: in Cell N7 enter =IF(SUM(N4:N6)=SUM(B7:M7), SUM(N4:N6), FALSE), and press the Enter key. (2) Calculate total income of every item: In Cell N4 enter =SUM(B4:M4), then drag the Fill Handle to apply this formula to Range N5:N6. (1) Calculate total income per month: In Cell B7 enter =SUM(B4:B6), then drag the Fill Handle to apply this formula to Range C7:M7. Step 2: Enter your budget data of income and expenses into the table, and calculate the total incomes of every month and every item:
Step 1: Prepare a table, and enter its row headers and column headers as following screen shot shown: The following steps will walk you through customizing a monthly budget template in Excel. Although there are so many budget templates for downloading, you may still want to make a custom monthly budget template based on your needs.
