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   Jun 20, 2013
user Gregg Manson (!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.