SUMIF is letting me down "selectively" and I'm not sure why (or I am letting SUMIF down, not sure which).
Please see two spreadsheet examples:
This one with original sample data.
And this one with a smaller made up set.
I am using the exact same formula in each:
On one sheet it works, on the other, well, not so much.