Consider an MS-Excel worksheet where cells A1 to A6 contain 90, 60, 150, 30, 50, 130 and cells B1 to B6 contain 70, 170, 20, 110, 40, 30. What will be the value of cell C1 containing the formula =SUMIF(A1:A6,">100",B1:B6)?

A90

B390

C50 ✓ Correct

D420

Correct answer: (C) 50

Explanation

SUMIF checks column A for values greater than 100 and adds the matching cells from column B.

Only A3 equal to 150 and A6 equal to 130 satisfy the greater-than-100 condition.

Their paired values in column B are 20 and 30, which total 50.

The value 90 is one of the column A values, not a valid sum here.

The values 390 and 420 come from summing B cells that fail the criterion.

The third SUMIF argument shifts the addition to column B while the test stays on column A.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.