summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormongo <andmarti@gmail.com>2017-04-19 16:03:46 -0300
committermongo <andmarti@gmail.com>2017-04-19 16:03:46 -0300
commit3cdb6e73ac14ba5b85a50b1a7615011713d4f7d9 (patch)
treeb75aef1ee62c3cf514e5efb85045ce0fe00caed8
parent02cc047bf9001b4c95e55f09028b1b5319a5c5b8 (diff)
added optional second argument doc. for @sum @prod @avg @count @max @min and @stddev functions
-rw-r--r--src/doc12
1 files changed, 10 insertions, 2 deletions
diff --git a/src/doc b/src/doc
index 74b84ae..de80ed4 100644
--- a/src/doc
+++ b/src/doc
@@ -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})