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