Totalling Sum of Parts in a 2 column array.

Hi,

I have a long list laid out in the following manner
Product A~~~~¦ 20
Product A Pt B~¦ 5
Product A Pt C~¦ 3
Product B~~~~¦ 15
Product B Pt B~¦ 10
Product C~~~~¦ 20
Product C Pt B~¦ 5
Product C Pt C~¦ 3
Product C Pt D~¦ 2

I need to total parts for each product as below

Product A~~~~¦ 28
Product B~~~~¦ 25
Product C~~~~¦ 30

However it will take to long to go through totaling each product with the 'autosum' key as each product can vary in number of parts.

Any suggestions would be greatly appreciated, thanks in advance!

Steve

=SUMPRODUCT(--(ISNUMBER(SEARCH("Product A",$A$1:$A$1000))),$B$1:$B$1000)

etc

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"steev_jd" <steev_jd.26vb5a_1146048601.0504@excelforum-nospam.com> wrote in
message news:steev_jd.26vb5a_1146048601.0504@excelforum-nospam.com...
>
> Hi,
>
> I have a long list laid out in the following manner
> Product A~~~~¦ 20
> Product A Pt B~¦ 5
> Product A Pt C~¦ 3
> Product B~~~~¦ 15
> Product B Pt B~¦ 10
> Product C~~~~¦ 20
> Product C Pt B~¦ 5
> Product C Pt C~¦ 3
> Product C Pt D~¦ 2
>
> I need to total parts for each product as below
>
> Product A~~~~¦ 28
> Product B~~~~¦ 25
> Product C~~~~¦ 30
>
> However it will take to long to go through totaling each product with
> the 'autosum' key as each product can vary in number of parts.
>
> Any suggestions would be greatly appreciated, thanks in advance!
>
> Steve
>
>
> --
> steev_jd
> ------------------------------------------------------------------------
> steev_jd's Profile:
http://www.excelforum.com/member.php...o&userid=33107
> View this thread: http://www.excelforum.com/showthread...hreadid=536333
>

=SUMIF(A1:A9,"Product A*",B1:B9)

HTH
--
AP

"steev_jd" <steev_jd.26vb5a_1146048601.0504@excelforum-nospam.com> a écrit
dans le message de
news:steev_jd.26vb5a_1146048601.0504@excelforum-nospam.com...
>
> Hi,
>
> I have a long list laid out in the following manner
> Product A~~~~¦ 20
> Product A Pt B~¦ 5
> Product A Pt C~¦ 3
> Product B~~~~¦ 15
> Product B Pt B~¦ 10
> Product C~~~~¦ 20
> Product C Pt B~¦ 5
> Product C Pt C~¦ 3
> Product C Pt D~¦ 2
>
> I need to total parts for each product as below
>
> Product A~~~~¦ 28
> Product B~~~~¦ 25
> Product C~~~~¦ 30
>
> However it will take to long to go through totaling each product with
> the 'autosum' key as each product can vary in number of parts.
>
> Any suggestions would be greatly appreciated, thanks in advance!
>
> Steve
>
>
> --
> steev_jd
> ------------------------------------------------------------------------
> steev_jd's Profile:
http://www.excelforum.com/member.php...o&userid=33107
> View this thread: http://www.excelforum.com/showthread...hreadid=536333
>