Question: 7. Enter a COUNTIFS function in cell B10 on the Summary worksheet. The function should count the number of investments on the Investment Detail worksheet

7. Enter a COUNTIFS function in cell B10 on the Summary worksheet. The function should count the number of investments on the Investment Detail worksheet that match the investment type in cell A10 on the Summary worksheet and achieved a gain that is greater than or equal to 15%. Use the Percent Gain/Loss column on the Investment Detail worksheet to evaluate the gains for each investment. Include cell capacity through row 25 when defining arguments that require a cell range and use absolute references when needed

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 Mathematics Questions!