Quote:
Originally Posted by baileyn3
I have data in column D1 all the way down and need to sum this. I need to sum it every three. The first group is easy, sum(d1:d3) results in E1, sum(d4:d6) results in E2, I need this to happen all the way down. I know it can be done because I've done it before but have forgotten how to, can anyone help?
|
On column F, input a series of numbers divisible by 3 starting from zero (F1=0, F2=3, F3=6, F4=9, etc.)
Then on E1:
=SUM(OFFSET($D$1,F1,0,3,1))
Drag this formula all the way down.