Monday, July 1, 2013

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.


Thanks in advance

Will
-----------------------------------------------------------------------------------------------------------------------------------------------------