Google Sheets get an average value from unique values in a single column

user_13946506 0
Viewed 744

On Google Sheets, I want to find an average for all values in rows that contain a unique value in one column. For example, I have a sheet like this:

  • Dog | 2
  • Dog | 1
  • Dog | 4
  • Cat | 3
  • Rat | 2
  • Cat | 1

And I want to create another table below it for the average value of each unique value in the row:

  • Dog | 2.33
  • Cat | 2
  • Rat | 2
google-sheets-formula google-sheets
1 Answers

You can use

=QUERY(Data!A1:B7;"SELECT A, AVG(B) GROUP BY A")

assuming your data (containing titles) are on the A and B columns of the sheet.

user_58413060
Related