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?