Average of multiple rows
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!
Help Article Resources
Check out the Formula Handbook template!