Long-time reader, first-time poster. Thanks in advance for any help.
Short version: I have a column of data that goes down hundreds of rows. This data is formula driven such that the first X number of rows could be zero depending on other inputs.
What I need to do is have another column of data that takes the average of every 12 entries in the first column but must always exclude any cells with zero.
In other words, if A1:A24 is all non-zero numbers, then I need B1:B12 to equal AVERAGE(A1:A12) and B13:B24 to equal AVERAGE A13:A24.
But, if A1:A6 equals zero, then B1:B6 must also equal zero and B7:B18 equaling AVERAGE A7:A18.
I need a formula I can put in one cell and copy down such that column B will always start averaging every 12 numbers once it encounters the first non-zero number in Column A.
Thanks in advance!
Bookmarks