Calculate average for rows matching conditions

[Trevor_Jenkins1]

I have added a column “Average” to a table called “Scorecard” which is calculating the average of column “Gross” in a table called “Rounds” using formula: AVERAGE(Rounds[Gross])

This gives me the average for all rows in table “Rounds”

I am trying to modify this to only calculate the average where the column “Hole” in table “Rounds” is equal to column “Hole” in the current table “Scorecard”.

Any help greatly appreciated.

[Marc_Dillon]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Trevor_Jenkins1]

Thanks Marc - have successfully combined with Average function to get desired result.

[Steve · Accepted solution]

help.appsheet.com

AVERAGE()

Arithmetic average of list items