How To Sum Every 5 Rows?

xlmaniac

Well-known Member
Joined
Jul 2, 2009
Messages
500
Office Version
  1. 2010
Platform
  1. Windows
Dear All,
I do have a huge data set spread across 1000 of rows.
I would like to add every 5 rows as per following sample.
My Data is across column B & the result should get populated in the column C.
Pls help with the formula.
AmountDesired Result
100
50
30
150
70400
200
250
300
350
4001500

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

sadboy309

Board Regular
Joined
Oct 15, 2014
Messages
88
You use formula:

Code:
[E6]=IF(MOD(ROW(),5)=1,SUM(D2:D6),"")

As Picture:

 

Watch MrExcel Video

Forum statistics

Threads
1,108,753
Messages
5,524,654
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top