» 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:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Windows XP for Dummies
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Microsoft Excel VBA Programming for the Absolute Beginner
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Marketing Planning for Services
No comments have been submitted.
