Sumif but different row of range critiria

Question

As in screenshot, criteria is E3, range to search is B:B, sum in C:C. but a cell is over a row of range 1 row.

Best regard

Answer 1

try like this:

=SUMIF(B2:B1000, E3, C1:C999)