Question: 1 . 0 0 Point: XL Activity 8 . 1 4 : Using the SUMIFS Function In cell K 3 , enter a SUMIFS function

1.00 Point: XL Activity 8.14: Using the SUMIFS Function
In cell K3, enter a SUMIFS function to calculate the total new customer sales for each employee. Select D3:D102 as the Sum range and press F4 to make it absolute. Select C3:C102 as the first Criteria_range and cell 13 as the Criteria. Select B3:B102 as the second Criteria_range and cell J3 as the Criteria. Make the references to both criteria ranges absolute.
 1.00 Point: XL Activity 8.14: Using the SUMIFS Function In cell

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 General Management Questions!