Average of multiple rows

Nick Varner
Nick Varner ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi - 

I am running into a problem with finding the average of multiple rows based on the two previous columns.

I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would then populate the 2017 and 2018 columns by Month on the other sheet.

Any ideas would be great!

Thanks

1.PNG

3.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!