Consider the following Snapshot of MS-EXCEL worksheet:
| A | B | C | D | |
| 1 | Roll Number | Test Marks-1 | Test Marks-2 | Total marks |
| 2 | 201 | 80 | 60 | 140 |
| 3 | 202 | 70 | 50 | 120 |
| 4 | 203 | 40 | 30 | 70 |
| 5 | 204 | 30 | 32 | 62 |
| 6 | 205 | 85 | 85 | 170 |
| 7 | 206 | 65 | 80 | 145 |
| 8 | 207 | 72 | 96 | 168 |
| 9 | 208 | 25 | 32 | 57 |
| 10 | 209 | 90 | 78 | 168 |
| 11 | 210 | 25 | 40 | 65 |
| 12 |
The formula = SUMIF(B2 ∶ B11,"<50", D2 ∶ D11) in cell D12 will result in
1
120
2
254
3
90
4
244