please help with the formulas for these!

H12 G H FINAL REPORT 6a. Using the data compiled on the "Master Data" tab, complete the 3 tables using FORMULAS 6b. Using the data compiled on the "Master Data" tab, recreate tables 1 & 2 using PIVOT TABLES Table 1 # of Loans 38 30 24 Sellers Ed's Quality Loan- Mart Ed's Quality Loan-Mart Ken's Discount Value Loans Ken's Discount Value Loans Shanna's Loan Headquarters Shanna's Loan Headquarters *Weighted by Current Balance Loan Rate >=5% =5% =5% 8.01% 8.01% =5% =5% =5% 8.01% 8.01%