I kept getting issues on counts lately between a list I would simply =sum, and then trying to verify after performing a =sumif function.

I was able to track it down to two line items:

ICBLTC8-B11 + ICBPTC8-B12 *WINDOW*
ICBLTC8-B11 + ICBPTC8-B12 + B148-C11B *WINDOW*

The quantities are 3 and 2 respectively.
ICBLTC8-B11 + ICBPTC8-B12 *WINDOW* 3
ICBLTC8-B11 + ICBPTC8-B12 + B148-C11B *WINDOW* 2


I took it to another column and did the following:
=SUMIF($D$1:$D$2,$G$1:$G$2,$E$1:$E$2)


And this is the result I get:
ICBLTC8-B11 + ICBPTC8-B12 *WINDOW* 5
ICBLTC8-B11 + ICBPTC8-B12 + B148-C11B *WINDOW* 2


So it looks like the SumIF is reading both as identical for the purposes of the shorter item, but not the longer one. How the heck do I avoid this?