# Making an averageif statement that uses multiple criteria like countifs does

✭✭✭✭✭

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!

• ✭✭✭✭✭✭

You would need an AVG/COLLECT

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

• ✭✭✭✭✭✭

You would need an AVG/COLLECT

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

• ✭✭✭✭✭

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

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

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!