How to Use the OFFSET Function in LibreOffice Calc
Offset lets you target cells in relation to a designated cell location. This video shows how to choose an offset range, and even dynamically choose disjointed ranges.
Formulas used in the video
Selecting One Cell
=OFFSET(B4,1,1)
Selecting a Range
=OFFSET(B4,1,1,1,3)
Selecting Every Third Row
=SUM(OFFSET(B4,2*(ROW(C1)-1)+1,4,1,3))
Official LibreOffice help page on using the Offset Function
https://help.libreoffice.org/latest/e...
Video Chapters
00:00 Targeting a Single cell
01:28 Targeting a cell range
01:54 Typical VALUE Error
02:17 Fixing the error
02:59 Another cell range example
03:32 How about negative values?
03:55 Using standalone SUM function
04:16 Magic of Offset- Selecting non-adjacent ranges
05:20 Selecting every third row
#LibreOfficeCalc