Question: Enter a COUNTIFS function in cell C 1 1 on the Summary worksheet to count the number of stores by size for the region number

Enter a COUNTIFS function in cell C11 on the Summary worksheet to count the number of stores by size for the region number typed into cell B9. Define the criteria_range1 argument with the range A4:A40 on the Sales and Inventory worksheet and the criteria1 argument with cell B9 on the Summary worksheet. Define the [criteria_range2] argument with the range F4:F40 on the Sales and Inventory worksheet and the [criteria2] argument with cell B11 on the Summary worksheet. Place absolute references on cell B9 in the criteria1 argument and both cell ranges used in the function.

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!