Hi,

I have a spreadsheet that has all the part numbers and their quantities in
different warehouse location. For example part number A has 5 in Loc. 1 and
10 in Loc. 2. The quantities are on seperate lines. I was told to use the
SumIf function to automatically add the total quatity for Part A. The
function is not working as I was told it would. It will only bring the
quantity in the first row it encounters for that particular part number. Am I
doing something wrong? Any assistance will be greatly appreciated.


Thank you