In an MS-Excel worksheet, column B (cells B2 to B11) holds the values 80, 70, 40, 30, 85, 65, 72, 25, 90 and 25, and column D holds the totals 140, 120, 70, 62, 170, 145, 168, 57, 168 and 65. The formula SUMIF(B2:B11, "<50", D2:D11) in cell D12 will result in

SUMIF adds only the D values whose matching B cell is below 50, giving 70 plus 62 plus 57 plus 65 which is 254.

The B values under 50 are 40, 30, 25 and 25, sitting in the third, fourth, eighth and tenth positions.

Their partner totals in column D are 70, 62, 57 and 65 respectively.

The value 120 would come from summing only some of these rows and is incomplete.

The value 90 is far too small to be the total of the four qualifying rows.

The value 244 arises from a single arithmetic slip and is not the exact sum.