Hosted on MSN15d
How to Use the OFFSET Function in ExcelExcel'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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results