yogi_Consolidate Table Of Quantities And Parts Description By Part Numbers

                           Google Spreadsheet   Post  #1716
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-30-2014
post by Steve G Horning:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/bnu1VgnqKzY)
Write a query to consolidate duplicate part numbers in a bill of material

I have a bill of material that has duplicate part numbers and I want to consolidate the quantities in column B for the duplicate parts.  The spreadsheet linked below has an example.  The Red area is before the consolidation and the Green area is the result I'm looking for.  I'm trying a query for the first time and I probably have some syntax wrong.  Any help would be greatly appreciated.

=query(A:E,"select * Sum(B) group by C order by A",1)

https://docs.google.com/spreadsheets/d/1LNH4MXyf2yohJXZh_9PSLwhkL3_VCvvc9t_NcYC8xq0/edit?usp=sharing

Thanks,

Steve

---------------------------------------------------------------------------------------------------------------------------------------------