Hi, I have a spreadsheet divided into 52 weeks across the columns. Each week
has 5 individual columns. Rows go to about 100, one for each employee.
Starting with week 1, Employee 1, I insert values (timesheet hours) into each
of the 5 individual columns. As the weeks go by I would like to have a
running total of the values in column 1 for each week, column 2 for each week
and so on. Can I set up a formula to get the SUM of every 6th column
recurring 52 times without me having to do it manually i.e. click every 6th
column 52 times in my formula? Thanks in advance! Pierian Spring