Excel's OFFSET function lets you create a reference that isquite literallyoffset ... sold when I enter their ID and a week number. To achieve this, in cell H4, I'll type I'm starting with cell ...

Here, we're tracking the number of goals a football team ... So, adding to our formula means that Excel will create a cell reference that starts in column B, and then minuses 1 from the value ...