Totalling Sum of Parts in a 2 column array.

[steev_jd]

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

 

[Bob Phillips]

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

 

[Ardus Petus]

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

HTH
--
AP

"steev_jd" <[email protected]> a écrit
dans le message de
news:[email protected]...