ROW, OFFSET, INDIRECT — Excel lesson

Task 1 of 3

Lesson theory

=ROW() returns the row number of the formula's cell. =ROW()-1 gives numbering that does not break when you sort or delete rows;
=OFFSET(start, rows, columns, height, width) returns a range shifted from a starting cell. This is how you get "the last 3 months": the table grows and the formula looks at the end by itself;
=INDIRECT("B"&F5) returns a reference built from text.

=SUM(OFFSET(C1,COUNT(C2:C13)-2,0,3,1)) is the sum of the last three filled months.

Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo

Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page

Practice is part of Pro

The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.