SumV
SumV
is a mathematical function that returns the summation of a
group of numeric values, rows, columns, or cells that are in visible, and not
hidden, rows and columns.
Syntax:
SumV(arguments)
where arguments
is one or more of the following
values:
Argument | Description |
---|---|
numeric |
A numeric value. For example, Numeric values can include decimals and negative values. See Numeric Arguments. |
row, column, or cell referenc |
A pointer to a row, column, or cell within a grid. |
function |
An embedded function. |
Examples:
Return the sum of three rows, where row 6 is a hidden row and will not be included in the result.
SumV([1], [6], [8])
Calculate the sum of three aggregate columns, where column G is a hidden column and will not be included in the result.
SumV([E], [G], [I])