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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!