Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Creating a single vertical array from multiple column arrays | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Array | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |