Hosted on MSN16d
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.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback