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

bdchapin

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. 

Nick Varner

This worked perfect. I think I was over thinking the problem. Thank you