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?
5 337 64b8f3ca23047f4c71cd1a38
Q:
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 Answer
- Workspace
- Discuss