Let's say I want to do a 10 line moving average over multiple columns. To simplify, I made this visual example:
I want to enter the algo into cell C12 and fill down. It should take a 10 line average, starting with column 1. As column 1 ends, or has blanks, more of the 10 will be taken from column 2, until it is only column 2.
C12 should equate to: =(sum(A3:A11)+B12)/10
C13 should equate to: =(sum(A4:A11)+sum(B12:13))/10
C14 should equate to: =(sum(A5:A11)+sum(B12:14))/10