diff options
author | mongo <andmarti@gmail.com> | 2017-04-19 16:03:46 -0300 |
---|---|---|
committer | mongo <andmarti@gmail.com> | 2017-04-19 16:03:46 -0300 |
commit | 3cdb6e73ac14ba5b85a50b1a7615011713d4f7d9 (patch) | |
tree | b75aef1ee62c3cf514e5efb85045ce0fe00caed8 | |
parent | 02cc047bf9001b4c95e55f09028b1b5319a5c5b8 (diff) |
added optional second argument doc. for @sum @prod @avg @count @max @min and @stddev functions
-rw-r--r-- | src/doc | 12 |
1 files changed, 10 insertions, 2 deletions
@@ -957,12 +957,20 @@ Commands for handling cell content: &Built-in Range Functions& The following functions return the result of performing an operation on - all valid (nonblank) entries in the given {range}. The optional expression - {expr} restricts which cells in {range} to operate on. (See above.) + all valid (nonblank) entries in the given {range}. The optional second + argument {expr} is an expression that is to be evaluated for each cell + in the specified range to determine which cells to include in the function. + Only those cells for which the expression evaluates to true (non-zero) + will be used in calculating the value of the function. + @sum({range}) @sum({range},{expr}) Sum up the values. + examples with optional {expr} argument: + @sum(D1:D20,D1>25) + @sum(D1:D20,E1>25) + @sum(D1:D20,@eqs(C1,"s")) @prod({range}) @prod({range},{expr}) |