Debug — SUMIFS Returns Zero on Threshold Criteria

An ops analyst's "high-value orders" rollup keeps returning 0 for every threshold. They wrote:

=SUMIFS($B$2:$B$16, $B$2:$B$16, "1000")

The intent was "sum of orders greater than $1000". But the criteria string "1000" has no comparison operator, so SUMIFS interprets it as "orders that equal exactly 1000" — and since no order in the table is exactly 1000, the result is 0.

The fix: put the operator inside the quoted string. Excel parses ">1000" as "greater than 1000". Common variants:

• Hardcoded: ">1000"
• Built from a cell: ">"&E2 (where E2 = 1000)
• Built from a cell with operator already embedded: just E2 (where E2 contains the literal string ">1000")

In this problem, column E already holds the operator-prefixed criteria strings (>500, >1000, >2000), so passing E2 / E3 / E4 straight into SUMIF works.

Your task:

1. In column F (Total Above Threshold), write a corrected SUMIF that sums column B values matching the criteria in column E.
2. The formula must drag-fill from F2 → F4.

Graded cells: F2 (>500), F3 (>1000), F4 (>2000).