Join Examsbook
Answer : 3. "=SUMIF(A2:A8,”>0″)"
There is a table in MS Excel which contains numbers from 0 to 10. If you want to add numbers greater than 5 in that table, then which of the following formula will be suitable?
5Q:
There is a table in MS Excel which contains numbers from 0 to 10. If you want to add numbers greater than 5 in that table, then which of the following formula will be suitable?
- 1=SUM(A2:A8)false
- 2=SUM(A2:A8,”false
- 3=SUMIF(A2:A8,”>0″)true
- 4=SUMIF(A2:A8, “false
- Show AnswerHide Answer
- Workspace
Answer : 3. "=SUMIF(A2:A8,”>0″)"
Explanation :
There is a table in MS Excel which contains numbers from 0 to 10. If you have to add numbers greater than 5 in that table, then the formula =SUMIF (A2:A8,”>0″) is suitable.