Consider an Excel spreadsheet where cells B1, B2 and B3 contain 3, 5 and 7, and cells C1, C2 and C3 contain 1, 3 and 5. What is the value of the formula =SUMIF(B1:B3, ">"&3, C1:C3)?

The function adds only the C values whose matching B cell is greater than 3, giving 8.

In B1:B3 the values 3, 5 and 7 are tested against the condition greater than 3.

The first B value 3 fails the test, so its aligned C value 1 is skipped.

B value 5 passes, contributing its aligned C value 3.

B value 7 passes, contributing C value 5, and 3 plus 5 makes 8.

SUMIF checks a range against one criterion and totals a parallel sum range.