2. Create a count-if formulas that will give you the total number of mansions sold (for the entire sheet)

Sheet 1 instructions: 1. Create a Sum-if formula that will give you the total cost of all apartments sold (for the entire sheet) 2. Create a count-if formulas that will give you the total number of mansions sold (for the entire sheet)A B C D 1 Home Type Region Number of Homes Sold Average Sale Price 2 Condo East 54 $ 110,000.00 3 Apartment East 1 S 90,000.00 4 Single Story East 276 S 225,000.00 5 Two Story East 101 S 410,000.00 6 Mansion East 5 S 625,000.00 7 Bungalow East 31 S 175,000.00 8 Condo West 487 S 249,000.00 9 Apartment West 120 S 129,000.00 10 Single Story West 88 S 320,000.00 11 Two Story West 202 S 545,000.00 12 Mansion West 57 S 750,000.00 13 Bungalow West 7 290,000.00 14 Condo South 4 S 90,000.00 15 Apartment South 2 S 75,000.00 16 Single Story South 442 136,000.00 17 Two Story South 167 S 200,000.00 18 Mansion South 45 S 538,000.00 19 Bungalow South 0 110,000.00 20 Condo North 80 88,000.00 21 Apartment North 44 ST 79,000.00 22 Single Story North 378 S 196,000.00 23 Two Story North 432 S 200,000.00 24 Mansion North 37 S 411,000.00 25 Bungalow North 12 S 100,000.00 26 Two Story West 1 625,000.00 27 Mansion West 276 $ 175,000.00 28 Bungalow West 101 S 249,000.00 29 Condo South 5 129,000.00 30 Apartment South 31 320,000.00