Average with certain criteria in other columns

Victoria Ganuelas

I am trying to create calculate the average for each person but only for rows that are greater than 11/30/20.

Dale Murphy

@Victoria Ganuelas Try this:

=AVG(COLLECT(Score:Score, Date:Date, >DATE(2020, 11, 30), Name:Name, =Check@row))

from:

That seems to work for me.

Cheers,

dm