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

Question

Question

This question was previously asked in

UGC NET Official Paper-I (Held On: 14 Mar, 2023 Shift 2)

Answer 1

Explanation:

The formula = SUMIF(B2:B11, "<50", D2:D11) in cell D12 will add up the total marks for all the students whose (test marks-1) are less than 50.
In the given worksheet, the (test marks -1) for the students with roll numbers 203, 204, 208, and 210 are less than 50, and their corresponding total marks are 70, 62, 57, and 65, respectively.

Therefore, the formula will evaluate to:

=SUMIF(B2:B11, "<50", D2:D11) = SUMIF(B2:B11, "<50", 70, 62, 0, 0, 0, 0, 0, 57, 0, 65) = 254