Hey guys,

I'm having trouble with a SUMIF formula only returning 0

I've looked around already for an answer, but I can't seem to find one that fixes my problem.

I have a the SUMIF formula set up in about 200 rows, and I have one instance of it working properly in the whole list. When I click and drag the working formula it still won't calculate anything but a 0 in the other cells.

HOWEVER, when I click and drag the cell that the working formula is looking to (range) it will start to work in the other formulas.

This made me believe that it was a formatting discrepancy (that the values in the range column were did not have valid formatting or something) so I used the formatting brush to apply identical formatting from the working cell to the other cells, but still no dice. This is REALLY wierding me out.

Any ideas?