Spreadsheet: 874524d1721124284-dynamic-excel-formular-that-can-not-change-aliginment-when-accounts-change-sunboy-charts-of-accounts-aligw
Sheet: Profit and Loss

I'm requesting for a dynamic excel formula that can aIign total income, total expenses and profit amounts if there is an addition of
income or expense account on the chart of tables
 |  |  |  |  |  |  |  |  |  |  | CHART OF ACCOUNTS
 |  |  | Income |  |  |  |  |  |  |  | Account Name | Group
Bus Fares | 208.84864 |  | Bus Fares |  |  |  |  |  |  |  | Long term marketable securities | Asset
Collegiate projects | 753.34688 |  | Collegiate projects |  |  |  |  |  |  |  | Accounts receivable | Current assets
Exam Fees | 283.43744 |  | Exam Fees |  |  |  |  |  |  |  | Fees | Income
Fees | 1634746.7664 |  | Fees |  |  |  |  |  |  |  | Collegiate projects | Income
Sundry Income | 246.14304 |  | Sundry Income |  |  |  |  |  |  |  | Short term marketable securities | Current assets
Total Income | 1636238.5424 |  | Total Income |  |  |  |  |  |  |  | Accounts receivable | Current assets
Expenses |  |  | Expenses |  |  |  |  |  |  |  | Bus Fares | Income
Accounting fees | 11934.208 |  | Accounting fees |  |  |  |  |  |  |  | NEC | Expense
Bank Charges | 2088.4864 |  | Bank Charges |  |  |  |  |  |  |  | NSSA | Expense
Cleaning | 223.7664 |  | Cleaning |  |  |  |  |  |  |  | Pension & Life Cover | Expense
Collegiate projects Expenses | 745.888 |  | Collegiate projects Expenses |  |  |  |  |  |  |  | Water | Expense
Electricity | 134.25984 |  | Electricity |  |  |  |  |  |  |  | Telephone & Internet | Expense
Feeding Programme | 1000 |  | Feeding Programme |  |  |  |  |  |  |  | Trade union | Expense
Fuel & Oil | 2983.552 |  | Fuel & Oil |  |  |  |  |  |  |  | PAYE | Expense
NEC | 100000 |  | NEC |  |  |  |  |  |  |  | Salaries & Wages | Expense
NSSA | 10000 |  | NSSA |  |  |  |  |  |  |  | Electricity | Expense
PAYE | 644100 |  | PAYE |  |  |  |  |  |  |  | Vehicle Maintenance | Expense
Payroll Expenses | 2000 |  | Payroll Expenses |  |  |  |  |  |  |  | Fuel & Oil | Expense
Pension & Life Cover | 29.83552 |  | Pension & Life Cover |  |  |  |  |  |  |  | Vehicle insurance & License | Expense
Printing & Stationery | 14.91776 |  | Printing & Stationery |  |  |  |  |  |  |  | Bank Charges | Expense
Property Maintenance | 49497.12768000001 |  | Property Maintenance |  |  |  |  |  |  |  | Property Maintenance | Expense
Salaries & Wages | 1924.39104 |  | Salaries & Wages |  |  |  |  |  |  |  | Feeding Programme | Expense
Subscriptions | 3729.440000000001 |  | Subscriptions |  |  |  |  |  |  |  | Printing & Stationery | Expense
Sundry Expenses | 895.0656000000001 |  | Sundry Expenses |  |  |  |  |  |  |  | Accounting fees | Expense
Telephone & Internet | 1372.43392 |  | Telephone & Internet |  |  |  |  |  |  |  | Sundry Expenses | Expense
Trade union | 29.83552 |  | Trade union |  |  |  |  |  |  |  | Cleaning | Expense
Vehicle hire | 52.21216 |  | Vehicle hire |  |  |  |  |  |  |  | Payroll Expenses | Expense
Vehicle insurance & License | 62.65459200000001 |  | Vehicle insurance & License |  |  |  |  |  |  |  | Workshop & Conference | Expense
Vehicle Maintenance | 29.83552 |  | Vehicle Maintenance |  |  |  |  |  |  |  | Subscriptions | Expense
Water | 1715.5424 |  | Water |  |  |  |  |  |  |  | Exam Fees | Income
Workshop & Conference | 14.91776 |  | Workshop & Conference |  |  |  |  |  |  |  | ZIMSEC fees paid | Expense
ZIMSEC fees paid | 73992.0896 |  | ZIMSEC fees paid |  |  |  |  |  |  |  | Collegiate projects Expenses | Expense
Total Expenses | 908570.4597119999 |  | Total Expenses |  |  |  |  |  |  |  | Plant & Equipment | Asset
Profit/(Loss) | 727668.0826880003 |  | Profit/(Loss) |  |  |  |  |  |  |  | ZiG Conversion | Equity
 |  |  |  |  |  |  |  |  |  |  | Sundry Income | Income
 |  |  |  |  |  |  |  |  |  |  | Accounts payable | Current liabilities
 |  |  |  |  |  |  |  |  |  |  | Vehicle hire | Expense
 |  |  |  |  |  |  |  |  |  |  | Land and Buildings | Asset
 |  |  |  |  |  |  |  |  |  |  | Bank | Current assets
 |  |  |  |  |  |  |  |  |  |  | Motor Vehilce | Asset