Forum Discussion
Average of Every Nth Row Problem.
How do I display the average of the values from every 12 rows of column C starting from row 6? (I.e. rows 6, 18, 30, 42...) I want the average to be displayed in cell J6. I have tried to figu...
Formula:
=AVERAGE(IF((MOD(ROW(C6:C1000),12)=6)*(C6:C1000<>""),C6:C1000))
- If your data extend below row 1000, adjust the ranges in the formula; it doesn't matter if the data range is smaller.
- If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
Thank you Hans, this worked wonderfully. I also applied it to several other cells (adjusting the MOD) that calculated the averages for the other rows based on what you sent over.
I was worried that this might not work in Teams, but it seems to do the trick. The only downside is that the system slows down a bit when calculating each time I add another batch of data.