Saturday, April 26, 2014

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:
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 DogHouse1
12 Circuit DogHouse1
12 Circuit DogHouse1
12 Circuit DogHouse1
12 Circuit DogHouse1
12 Circuit DogHouse2
12 x 12 10'8
12 x 12 5 Way Corner5
And I'd like it to compile it like this if possible...
12 Circuit DogHouse7
12 x 12 10'8
12 x 12 5 Way Corner5

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