and continue my OFFSET formula. The next stage is to tell Excel how many rows to offset downwards. This will be the current month (cell F1) minus three: =OFFSET(Table1[[#Headers],[Month]],SUM(F1-3 ...

Excel formulas are essential for unlocking the full potential of the program. If you're new to Excel and curious about what formulas are and how they work, hereâ s everything you need to know.