You want to count the number of houses in one city 5 In cell (32. insert the CDUNTIF function to count the number of houses in the city of Atpine. Use mixed references for the range; and use a relative reference to cell A2. Copy the function and use the Paste Formulas option to paste the function in the range C3325 so that the border in cell C5 is preserved. You want to calculate the total commissions for each agent [the 5 condition]. In cell Bi". insert the SUMIF function to total the commissions by agent. Use mixed references for the ranges; and use a relative reference to cell AT. Copythe function and use the Paste Formulas option to paste the function in the range BEBE so that the borders are preserved. The topmiddle section of the spreadsheet is designed for summary 5 statistics for multiple conditions. You will calculate the number of houses sold for each agent when he or she served as a Dual Agent (DA). Use mixed references for ranges and the agent code condition in cell .13. Use relative cell references to the agent condition in cell E2. 1When you copy the formulas, use the paste Formulas options to preserve border formatting. In cell F2, insert the CDUNTIFS function in cell F2 to count the number of houses sold by the first agent [cell E2) who was a Dual Agent {DA} {.13} for that house. Copy the function to the range F3:F4 and preserve the bottom border for cell F4