Excel's OFFSET function ... cells in row 1 contain the word "Week" followed by a number: =COUNTIF(1:1,"Week*") I can now use this information to work out Jason's total and average units sold.