Excel Formula.JPGExcel Formula.JPG

Hi,

I want to create a formula that will give me the average of the column AM but with the range of the value from 1 - 10 from the column AN. In simple words, I want the the average of the last 10 cells from column AM when the number 10 is entered in column AN.

Any suggestions?

Thanks