average function using a location from another cel

I want to averaged 10 numbers in a row by specifying the bottom cell location from another cell where I have generated a cell cell location with =Address(count (d1:d319)-1+6,2,4). This yields the location B309 in this cell. I want to referr to this location and the 9 cells above it to take an average. The B309 address will change from time to time depending on any cells filled in between d309 and d319.

 

I am using Office 2013 hm & student v15.0.4971.1002

By: steve

Leave a Reply

Your email address will not be published. Required fields are marked *