A B Insert... Asse Delete (2 2 Entry # 3 A Cash Bename 1234 For the Period Ended 12/3 1 4 Move or Copy... 2 5 Cash 1 View Code 6 Accounts Receivable NUNYA BUSINE Balance Sheet B CDE Type this formula in cell B5 of the Balance Sheet worksheet and press Enter. SUMIF(HFS!$2:$2,45,HFS!$12:$12) =SUMIF(HFS!$2:$2,A5,HFS!$12:$12) G Right-click Horizontal Financial Statement tab. rotect Sheet... 7 Total Assets 8 ab Color Hide Horizon 9 Liabilities 10 Common Stock 11 Retained Earnings A B D 12 Total Liabilities/Equity Assets Entry # Cash Accounts 13 14 Your turn: Complete the balance sheet by copying the SUMIF function and adding totals as needed. +Receivable SUMIF(HFS!$2:$2,A5,HFS!$12:$12) Type HFS, and then press Enter. Shortening tab names, even temporarily makes formulas easier to write. 8 9 HFS Balance Shee... 17 18 19 range HFS!$2:$2 where to look (in this case across row 2 of the HFS worksheet) criteria A5 what to look for (in this case the word Cash) HFS Balance Sheet Income Statement sum_range HFS!$12:$12 the cells to sum (in this case across row 12 of the HFS worksheet) Chart of Accounts