Question: 1 . 0 0 Point: XL Activity 8 . 1 4 : Using the SUMIFS Function In cell K 3 , enter a SUMIFS function
Point: XL Activity : Using the SUMIFS Function
In cell K enter a SUMIFS function to calculate the total new customer sales for each employee. Select D:D as the Sum range and press F to make it absolute Select C:C as the first Criteriarange and cell as the Criteria. Select B:B as the second Criteriarange and cell J as the Criteria. Make the references to both criteria ranges absolute
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
