Hi All,

I have a range of data A1:A500 and I'd like to find the sum of every non-consecutive seven cells. For example, I'd like to sum A1:A7 and then sum A8:A14. Can someone please help? Any help would be greatly appreciated. Thanks.