Spreadsheet: 874520d1721121889-dynamic-excel-formular-that-can-not-change-aliginment-when-accounts-change-charts-of-accounts
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
 |  |  |  |  |  |  |  |  |  |  | Account Name | Group
Bus Fares |  |  |  |  |  |  |  |  |  |  | Long term marketable securities | Asset
Collegiate projects |  |  |  |  |  |  |  |  |  |  | Accounts receivable | Current assets
Exam Fees |  |  |  |  |  |  |  |  |  |  | Fees | Income
Fees |  |  |  |  |  |  |  |  |  |  | Collegiate projects | Income
Sundry Income |  |  |  |  |  |  |  |  |  |  | Short term marketable securities | Current assets
Total Income |  |  |  |  |  |  |  |  |  |  | Accounts receivable | Current assets
Expenses |  |  |  |  |  |  |  |  |  |  | Bus Fares | Income
Accounting fees |  |  |  |  |  |  |  |  |  |  | NEC | Expense
Bank Charges |  |  |  |  |  |  |  |  |  |  | NSSA | Expense
Cleaning |  |  |  |  |  |  |  |  |  |  | Pension & Life Cover | Expense
Collegiate projects Expenses |  |  |  |  |  |  |  |  |  |  | Water | Expense
Electricity |  |  |  |  |  |  |  |  |  |  | Telephone & Internet | Expense
Feeding Programme |  |  |  |  |  |  |  |  |  |  | Trade union | Expense
Fuel & Oil |  |  |  |  |  |  |  |  |  |  | PAYE | Expense
NEC |  |  |  |  |  |  |  |  |  |  | Salaries & Wages | Expense
NSSA |  |  |  |  |  |  |  |  |  |  | Electricity | Expense
PAYE |  |  |  |  |  |  |  |  |  |  | Vehicle Maintenance | Expense
Payroll Expenses |  |  |  |  |  |  |  |  |  |  | Fuel & Oil | Expense
Pension & Life Cover |  |  |  |  |  |  |  |  |  |  | Vehicle insurance & License | Expense
Printing & Stationery |  |  |  |  |  |  |  |  |  |  | Bank Charges | Expense
Property Maintenance |  |  |  |  |  |  |  |  |  |  | Property Maintenance | Expense
Salaries & Wages |  |  |  |  |  |  |  |  |  |  | Feeding Programme | Expense
Subscriptions |  |  |  |  |  |  |  |  |  |  | Printing & Stationery | Expense
Sundry Expenses |  |  |  |  |  |  |  |  |  |  | Accounting fees | Expense
Telephone & Internet |  |  |  |  |  |  |  |  |  |  | Sundry Expenses | Expense
Trade union |  |  |  |  |  |  |  |  |  |  | Cleaning | Expense
Vehicle hire |  |  |  |  |  |  |  |  |  |  | Payroll Expenses | Expense
Vehicle insurance & License |  |  |  |  |  |  |  |  |  |  | Workshop & Conference | Expense
Vehicle Maintenance |  |  |  |  |  |  |  |  |  |  | Subscriptions | Expense
Water |  |  |  |  |  |  |  |  |  |  | Exam Fees | Income
Workshop & Conference |  |  |  |  |  |  |  |  |  |  | ZIMSEC fees paid | Expense
ZIMSEC fees paid |  |  |  |  |  |  |  |  |  |  | Collegiate projects Expenses | Expense
Total Expenses |  |  |  |  |  |  |  |  |  |  | Plant & Equipment | Asset
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