Back to lesson
1. Which of the following is true about the SUMIF function?
The function is case sensitive
If there are no exact matches to the condition, SUMIF will take the best approximation
A dynamic condition requires concatenation (e.g. the use of ‘&’)
2. The syntax of SUMIF is SUMIF(Range,Criterion,Sum_Range). Which argument is not necessarily required?
Range (if not specified, Sum_Range is used instead)
Sum_Range (if not specified, Range is used instead)
3. In this example, Business Units A, B, C and D make sales as recorded. What should the amount be displayed in cell G5 if the formula is =SUMIF(B5:B16,B12,C5:C16)?
The sum of all B’s sales, i.e. $1,800
The sum of all A’s sales, i.e. $1,000
The sum of all C’s sales, i.e. $2,700
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement