Making an averageif statement that uses multiple criteria like countifs does

Dave from JBM

Where I have a "Trainee" column, a Rubric Week" column, and a "Score" column that sums the scores of multiple criteria, I am trying to get a running average column for multiple weeks.

To say it another way, I have two criteria that I need to meet. I need to average the scores where the "Rubric Week" is a certain week and the "Trainee" references @row

currently i'm at =averageif(and([Rubric Week]=1)trainee:trainee,Trainee@row,Score:Score) and getting #unparseable.

any help would be appreciated!

Paul Newcome

You would need an AVG/COLLECT

=AVG(COLLECT(Score:Score, [Rubric Week]:[Rubrick Week], @cell = 1, Trainee:Trainee, @cell = Trainee@row))

Paul Newcome

You would need an AVG/COLLECT

=AVG(COLLECT(Score:Score, [Rubric Week]:[Rubrick Week], @cell = 1, Trainee:Trainee, @cell = Trainee@row))

Dave from JBM

DAAAAAAAAANGG!! @Paul Newcome you are a beast! I got it with:

=AVG(COLLECT(Score:Score, [Rubric Week]:[Rubric Week], 1, Trainee:Trainee, Trainee@row))

Paul Newcome

Happy to help. 👍️