Daily To Weekly Formulations Down Columns

  • Thread starter Thread starter Vanguard
  • Start date Start date
V

Vanguard

I have a spreadsheet that has daily values in one column
with data in the second. On another tab, I have weekly
rollup data to give me a sum or average of a week's worth
of data.

The issue is that It takes forever to type the formulas
to sum (or average) the weekly data [=sum(b1:b7)],[=sum
(b8:b14)], and so on down the column for the entire
year. Without using VB, is there an easy way to populate
the formula going down the column instead of typing it 52
times? When I drag down the formula, it only increases
the cell by 1 (b2:b8),(b3:b9).etc.
 
Hi
if you start your sum formula in row 1 try
=SUM(OFFSET($B$1:$B$7,(ROW()-1)*7,0))
copy down

Frank
 
Back
Top