=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