» Calculating the Average of Every Nth Value
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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))}
Book Store:
Recommended Books:
- Understanding Financial Statements
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Business Plans For Dummies®
- Microsoft Windows XP Step by Step (With CD-ROM)
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
No comments have been submitted.
