» Calculating the Average of Every Nth Value
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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))}
Book Store:
Recommended Books:
- Microsoft Access Version 2002 Step by Step
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Business Analysis with Microsoft Excel (2nd Edition)
- Microsoft Excel Version 2002 Step by Step
- How to Use Financial Statements: A Guide to Understanding the Numbers
No comments have been submitted.
