Question: Insert the COUNTIFS function in cell F 2 to count the number of houses sold by the first agent ( cell E 2 ) who

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. Copy the function to the range F3:F4 and preserve the bottom border for cell F4.
Insert the SUMIFS function in cell G2 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. Copy the function to the range G3:G4 and preserve the bottom border for cell G4.
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. Copy the function to the range H3:H4 and preserve the borders in the range H3:H4.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!