SumIf function

[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

[VBA Noob]

Hi

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

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

VBA Noob

[Richard]

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

Richard

"VBA Noob" wrote:

>
> Hi
>
> Say Col A has part No. Col b has Loc 1, col C has Loc 2 then this
> formula should work
>
> =SUMPRODUCT(--(A2:A15="A")*(B2:B15)+(C2:C15))
>
> VBA Noob
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=561274
>
>

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

"Richard" <[email protected]> wrote in message
news:[email protected]...
> the information is on seperate rows not columns. Shouldn't SumIf work?
>
> Richard
>
> "VBA Noob" wrote:
>
> >
> > Hi
> >
> > Say Col A has part No. Col b has Loc 1, col C has Loc 2 then this
> > formula should work
> >
> > =SUMPRODUCT(--(A2:A15="A")*(B2:B15)+(C2:C15))
> >
> > VBA Noob
> >
> >
> > --
> > VBA Noob
> > ------------------------------------------------------------------------
> > VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
> > View this thread:
http://www.excelforum.com/showthread...hreadid=561274
> >
> >