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 F to count the number of houses sold by the first agent cell E who was a Dual Agent DAJ for that house. Copy the function to the range F:F and preserve the bottom border for cell F
Insert the SUMIFS function in cell G to sum the selling prices of the houses sold by the first agent cell E who was a Dual Agent DAJ for that house. Copy the function to the range G:G and preserve the bottom border for cell G
Insert the MAXIFS function in cell H to display the highestprice house sold by the first agent cell E who was a Dual Agent DAJ for that house. Copy the function to the range H:H and preserve the borders in the range H:H
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
