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


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

Totalling Sum of Parts in a 2 column array.
 

=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" wrote in
message ...

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

Totalling Sum of Parts in a 2 column array.
 

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

HTH
--
AP

"steev_jd" a écrit
dans le message de
...

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