By Auda Caouette at March 15 2019 18:14:17
Once you put your numbers in, how do you compare to the national average or some other standard guideline? The budgeting worksheet should give you some idea of how you compare in each of the above categories. Then you can make some decisions if you're over or under spending in some areas. The beauty of using worksheets is not only to see where your money is going but to see how you compare to a standard guideline.
Creating a Sum across worksheets. This is also an inter_active link. If a number changes on one worksheet, the sheet with the summary formula will also be updated. If a worksheet is inserted between worksheets in the sum, the sum will automatically be updated. Some of the disadvantages of this method are that all of the linked cells must be in the same location on all worksheets. Also, you can only sum one cell at a time (although you can copy the formula to other cells in the summary worksheet.) Using group mode to create identical spreadsheets will help when using the sum function across worksheets. This method is also limited to within a workbook and cannot be done across workbooks.