SumIf function

[Guest]

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

 

[VBA Noob]

Hi

Say Col A has part No. Col b has Loc 1, col C has Loc 2 then thi
formula should work

=SUMPRODUCT(--(A2:A15="A")*(B2:B15)+(C2:C15))

VBA Noo

 

[Guest]

the information is on seperate rows not columns. Shouldn't SumIf work?

Richard

 

[Bob Phillips]

That example is rows.

Why don't you give a data example?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)