Photo by Rubaitul Azad / Unsplash

Calculate Average By Group or Unique Columns in Google Sheet

Google Sheet Apr 30, 2024

For the below list of values I want to group by Coin(Market) and Average the values ( Price) of each coin .

First I have to get the Coins in Unique and we can use the below formula

=UNIQUE(B7:B14)

The result is

Now I have to calculate the average of each coins that i purchased, for that I can apply the below formulat using AVERAGEIF

=AVERAGEIF($B$7:$B$14, H7, $D$7:$D$14)

Tags