SumIf function

R

Richard

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
 
V

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
 
B

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)
 
Top