Skip to main content
- E.g. d1:d-3 or m1:m3 – use two references separated by a colon to define a range of columns, rows or measures.
- Reference ranges can of course also be relative, e.g. -2:0 meaning a range starting 2 columns/rows back and up to the current column/row
- A “classical” reference range could be an accumulation: d1:0 meaning from the first column/row to the current – or reverse d-1:0 meaning from the last column/row to the current.