I have a number of columns which calculate a series of moving averages with formulas such as
=average(E2:E4) (for a 3 day moving average). I'd like to use array formulas instead because I'm constantly adding data to the list. The problem is that the array I'm using for the average
E1:E3 is in the same direction as the array formula I'd like to create, where the values would be, for example,
Example with a 3-day moving average
edit: I'm sorry. I was trying to be too succinct with my question. I would like a more generic formula, because I'm doing not just a 3-day moving average, but a 7 day, 14 day, and a 30 day each in separate columns. I don't really want to have to sum 30 items in a denominator.
Thank you for the responses so far.