Tip Printed from ExcelTip.com

---

Calculating the Average of Every Nth Value


Problem:

Calculating the average of the values from every 4th line in a list.

Solution:

Use the AVERAGE, IF, MOD, and ROW functions in the following Array formula:
{=AVERAGE(IF((MOD(ROW($B$2:$B$10)-ROW($B$2)+1,C2))=0,$B$2:$B$10))}