SUMIF not adding correctly
I'm trying to add Units Used of a particular Raw Material with a certain Inventory Id. I've used the formula:
=SUMIF([Inventory ID]:[Inventory ID], [Inventory ID]@row, [Units Used]:[Units Used])
I am expecting a positive number, but the result it "0". If I copy the formula to all the rows in the Total Used column, all results are "0".
What am I missing?