» Summing Groups of Every N Values in a Row
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: Cells in the range B2:M2 contain numerical values, and the row above contains matching serial numbers.
We want to subdivide the values into batches of three and calculate the sum of each batch.
Solution 1:
Use the SUM and INDEX functions as shown in the following formula:
=SUM(INDEX($B$2:$M$2,3*A6-2):INDEX($B$2:$M$2,3*A6))
Solution 2:
Use the SUM and OFFSET functions as shown in the following formula:
=SUM(OFFSET($B$2:$D$2,0,3*(A6-1)))
Book Store:
Recommended Books:
- 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
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Adventure Capitalist: The Ultimate Road Trip
- Financial Modeling - 2nd Edition
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.

