Average of multiple rows
Nick Varner
✭✭✭
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
Comments
-
I cannot say much without a better glimpse of the source data. But an Average would be a Sum / Count. and you should be able to use sumif() and countif() to only get the data that matches your criteria.
-
This worked perfect. I think I was over thinking the problem. Thank you
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!