yogi_Compute Sum Of Quantities By Various Types of Equipment From Merged Data (from a number of sheets)

                                         Google Spreadsheet   Post  #1617
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-26-2014
post by Michael Lance: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/7LtZTjNHCQs)
How do you combine like information with query and sum?

Here is my spreadsheet:

https://docs.google.com/spreadsheets/d/1Ty-YkaCrWqELslLlcV2WZBrS8zXlc5O4tZBABPLuZ_4/edit?usp=sharing

On the "By Vendor" sheet I am using Query to pull data from several sheets organized by vendor. What I am missing is how to get the formula to add up all of the like gear types and their quantities into a single listing for that gear type with the total of the specific gear type added up. 

Example right now it looks like this...

12 Circuit DogHouse	1
12 Circuit DogHouse	1
12 Circuit DogHouse	1
12 Circuit DogHouse	1
12 Circuit DogHouse	1
12 Circuit DogHouse	2
12 x 12 10'	8
12 x 12 5 Way Corner	5

And I'd like it to compile it like this if possible...

12 Circuit DogHouse	7
12 x 12 10'	8
12 x 12 5 Way Corner	5

For some reason I can't figure out the correct syntax for adding the sum function in...

Maybe there is a better way?

Thanks! -M

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