Which function, when entered into cell G7, allows you to determine the sum total of annual sles for market regions 18 and greater?
- =SUMIF(G2:G6,”>17″,F2:F6)
- =SUM(G2:G6,”>=18,F2:F6)
- =SUMIF(F2:F6,”>=18″,G2:G6)
- =SUM(F2:F6,”18+”,G2:G6)
The correct answer is:
- =SUMIF(F2:F6,”>=18″,G2:G6)
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers