• Mathematical and Financial Functions
  • ABS Function
  • AVERAGE Function
  • CGROUP Function
  • CGROUPT Function
  • COLCOUNT Function
  • COUNTIF function
  • EXP Function
  • FV Function
  • LOG Function
  • Mathematical and Financial Functions
  • MAX Function
  • MEDIAN Function
  • MIN Function
  • MKDEC Function
  • MKINT Function
  • MOD Function
  • POS Function
  • PV Function
  • R Function
  • RATIO Function
  • RC Function
  • RCNV Function
  • RCR Function
  • RCTOTAL Function
  • ROUND Function
  • ROWCOUNT Function
  • RR Function
  • RRTOTAL Function
  • STDDEV Function
  • SUM Function
  • TOTAL Function

RRTOTAL Function

The RRTOTAL function returns a total for a range of cells obtained by row relative table referencing based on the current cell.

Syntax

RRTOTAL(integer,integer)

The first integer is the relative row position of the first cell in the sequence and the second integer is the relative row position of the final cell in the sequence relative to the current cell.

Example 1

Entering RRTOTAL(-100,-1) in table cell ABC.a101 returns the total of all cells in the range ABC.a1 to ABC.a100.

Note: This function will accept either positive or negative numbers for the relative reference. Specifying a value of 0 or values that span 0 is not valid.

Example 2

The function also accepts an additional parameter that allows it to re-reference automatically.

Entering RRTOTAL(-100#,-1#) in table cell ABC.a101 returns the total of all cells in the range ABC.a1 to ABC.a100. If any rows are inserted or deleted between the cell containing the formula and the source cell, the formula automatically updates itself to reference the original range. It also updates itself if cells referenced in the formula are renumbered. For example, if a row is inserted between row 2 and row 3, the formula is updated to read RRTOTAL(-101#,-1#).

Related Topics

• Mathematical and Financial Functions