Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Beginner
Which of the following is the correct syntax for the SUMIFS function?
=SUMIFS(Sum_Range, Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])
=SUMIFS(Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …],Sum_Range)
=SUMIFS([Sum_Range], Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])
Don’t know
2
Beginner
If no set of values satisfies the criteria in a SUMIFS formula (where the Sum_Range contains only numerical values), what will the result of the formula be?
#VALUE!
Zero
#DIV/0!
Don’t know
3
Beginner
In the SUMIFS function, if criterion ranges are not of equal dimensions (i.e. same number of rows / columns), what error message would Excel display?
#VALUE!
#N/A
#REF!
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement