I work at a dealership and I was wondering if there was a way to calculate average satisfaction scores for 2 separate brands on the same spreadsheet so that it updates automatically when I submit more data. 

In terms of “if, then” statements essentially “if column c say BRAND A or B, then calculate the average  of the numbers in the same row on column d”.

​I work at a dealership and I was wondering if there was a way to calculate average satisfaction scores for 2 separate brands on the same spreadsheet so that it updates automatically when I submit more data. In terms of “if, then” statements essentially “if column c say BRAND A or B, then calculate the average  of the numbers in the same row on column d”.   Read More

​