» 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:
- Excel 2002 Power Programming with VBA
- Special Edition Using Microsoft Access 2002
- Marketing Management
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Financial Risk Manager Handbook, Second Edition
No comments have been submitted.
