43975000 50
43865000 100
43828000 5
43828001 21

Assume the block of data above, and that I want to do a sumif formula, with
the range being the 1st column, but only the first 5 characters of said cells
in the range. Example, the criteria will be 43828 and I want the result to be
the value 26. The reason is this is a basically a rollup of values in column
B when the match is on the first 5 characters.

Does this make sense?

Thanks,