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