Consider the following snapshot of MS-EXCEL worksheet :
| A | B | C | |
| 1 | 90 | 70 | |
| 2 | 60 | 170 | |
| 3 | 150 | 20 | |
| 4 | 30 | 110 | |
| 5 | 50 | 40 | |
| 6 | 130 | 30 | |
| 7 |
What will be the value of the cell C1 containing the formula =SUMIF(A1:A6,“>100%,B1:B6) in the above worksheet ?
1
90
2
390
3
50
4
420