I have a columm of data and need to calculate the sum of every seven (7) values. For Example, the sum of values 1 thru 7 (inclusive), then the sum of values 2 thru 8, then 3 thru 9, etc....
This is simple enough, but the problem is that the data is incomplete, and prior to summing the values I...