#Cut cell b7 and paste it to cell e12 code

L6 Jx F 1 J K G H Total Sold Highest Sold Prices Price Total # Sold Agent Codes and Commission Rates |ВА Buyer's Agent 2.75% DA 5.50% SA Seller's Agent 3.25% Dual Agency Input for Bonus Percent of List Days on Market Bonus Amount $ 100% 30 1,000 Days on Market Agent Commission Bonus А. Copy the function to the range H3:H4 and preserve the borders in the range H3:H4. In cell H2, insert the MAXIFS function in cell H2 to display the highest-price house sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for that house. When you copy the formulas, use the paste Formulas options to preserve border formatting.

Use relative cell references to the agent condition in cell E2.

#Cut cell b7 and paste it to cell e12 code

Use mixed references for ranges and the agent code condition in cell J3. Now, you will calculate the highest-price house highest-price house sold for each agent when he or she served as a Dual Agent (DA). Copy the function to the range G3:G4 and preserve the bottom border for cell G4. In cell G2, insert the SUMIFS function to sum the selling prices of the houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for that house. Use mixed references for ranges and the agent code condition in cell 33. 10 5 You are ready to calculate the total value of those houses for each agent when he or she served as a Dual Agent (DA). Copy the function to the range F3.F4 and preserve the bottom border for cell F4. In cell F2, insert the COUNTIFS function in cell F2 to count the number of houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for that house. You will calculate the number of houses sold for each agent when he or she served as a Dual Agent (DA). The top-middle section of the spreadsheet is designed for summary statistics for multiple conditions. Copy the function and use the Paste Formulas option to paste the function in the range B8:B9 so that the borders are preserved.

Use mixed references for the ranges and use a relative reference to cell A7. In cell B7, insert the SUMIF function to total the commissions by agent.

8 5 5 9 5 You want to calculate the total commissions for each agent (the condition). Copy the function and use the Paste Formulas option to paste the function in the range C3:05 so that the border in cell C5 is preserved. Use mixed references for the range, and use a relative reference to cell A2. In cell C2, insert the COUNTIF function to count the number of houses in the city of Alpine. Transcribed image text: 7 5 You want to count the number of houses in one city.