yogi_Setup To Record Sum Of Sales By Store Automatically And Dynamically

                                          Google Spreadsheet   Post  #1265
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 01, 2013
user cossieWill (http://productforums.google.com/forum/?zx=6rcla7maju2x#!category-topic/docs/spreadsheets/hJJ7sa1Gt6A)
Query a range - group by column 1 and sum column 2

Hiya All

I cant work out how to create a overview for a simple data file I have.

I need to be able to group by the "store" and then count(sum i think) the values in "order total". More stores could be added, so having this part dynamic would be great.

Here is an example of the data and the desired result.

https://docs.google.com/spreadsheet/ccc?key=0AltNukvJFRJidFFSZ2htTlU5R1FQNE5sRnI0YlR2dUE

Thanks in advance

Will

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