Thursday, June 20, 2013

yogi_Compute Row By Row Average Number Of Each Brand in Column A

                                          Google Spreadsheet   Post  #1254
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 20, 2013
user Gregg Manson (http://productforums.google.com/forum/?zx=1un23xjfx15h#!category-topic/docs/spreadsheets/RjG5O1dQ80U)
Average with multiple criteria
Help - attempting to average a column by brand, exapmle below

  A         B
Audi     265
Audi     125
BMW   298
BMW   890


Would like to return in a cell the average for each Brand.  I have 20 different Brands and apx 100 rows of data.

Really appreciate the assistance.
-------------------------------------------------------------------------------------------------------------------------------------------------