If you fill in blank cells for the Ledger Block, then you can go direct from the Ledger to the Budget, by using a SUMIF-INDEX-MATCH
SUMIF the Ledger Set# matches the BUDGET cell, then INDEX the values you want to sum, and match to the correct form, the following example we are doing for "Amort". In cell BUDGET!E15, place this formula, then drag down:
then you will need to increase the decimal places by two places otherwise you will get whole dollar amounts
you can then adjust the formula for rentals etc, and for the other forms (1,2,3,4, instead of "Amort")
the results are completely different to the values you had because it seems you did not supply matching data between the Ledger and BUDGET.
Bookmarks