What are the Excel commands to get the consolidated figures shown here?

B E F G H Consolidation Entries Debit Credit 2 D 1 CONSOLIDATION WORKSHEET Innovus ChipTech 3 Revenues $ (990,000.00) $ (210,000.00) 4 Cost of Goods Sold $ 500,000.00 $ 90,000.00 5 Depreciation Expense $ 100,000.00 $ 5,000.00 6 Amortization Expense $ 55,000.00 $ 18,000.00 E 7 Dividend Income $ (40,000.00 $ I 8 Net Income $ (375,000.00) $ (97,000.00) Consolidated $ (1,200,000.00) $ 590,000.00 $ 105,000.00 $ 93,000.00 $ $ (412,000.00) $ 20,000.00 $ 40,000.00 9 10 Retained Earnings 1/1 $(1,555,000.00) $ (450,000.00) S $ 450,000.00 *C $ 60,000.00 $ (1,615,000.00) 11 Net Income $ (375,000.00) $ (97,000.00) S (412,000.00 12 Dividends Declared $ 250,000.00 $ 40,000.00 I $ 40,000.00 $ 250,000.00 13 Retained Earnings 12/31 $(1,680,000.00) $ (507,000.00) $ (1,777,000.00) 14 15 Current Assets $ 960,000.00 $ 355,000.00 $ 1,315,000.00 16 Investment in ChipTech $ 670,000.00 *C $ 60,000.00 17 S $ 580,000.00 18 A $ 150,000.00 $ 19 Equipment (net) $ 765,000.00 $ 225,000.00 $ 990,000.00 20 Trademark $ 235,000.00 $ 100,000.00 A $ 36,000.00 E $ 4,000.00 $ 367,000.00 21 Existing Technology $ $ 45,000.00 A $ 64,000.00 $ 16,000.00 $ 93,000.00 22 Goodwill $ 450,000.00 $ A $ 50,000.00 $ 500,000.00 23 Total Assets $ 3,080,000.00 $ 725,000.00 $ 3,265,000.00 24 25 Liabilities $ (780,000.00) $ (88,000.00) $ (868,000.00) 26 Common Stock $ (500,000.00) $ (100,000.00) S $ 100,000.00 $ (500,000.00) 27 Additional Paid-in-Capital $ (120,000.00) $ (30,000.00) S $ 30,000.00 $ (12,000.00) 28 Retained Earnings 12/31 $(1,680,000.00) $ (507,000.00) $ (1,777,000.00 29 Total Liabilities and Equity $ (3,080,000.00) $ (725,000.00) $ 850,000.00 $ 850,000.00 $ (3,265,000.00) 30 31