summaryrefslogtreecommitdiff
path: root/calc_test.go
diff options
context:
space:
mode:
authorxuri <xuri.me@gmail.com>2020-06-04 00:35:54 +0800
committerxuri <xuri.me@gmail.com>2020-06-04 00:35:54 +0800
commitb6dd7648a142901655cc4f76cb7d3a6e73338c8f (patch)
tree41b6d815a5f0b9129dd146c7203d8d1714bff882 /calc_test.go
parentb62950a39ef2063ec19c221a32d37bd01f197472 (diff)
fn: COUNTA
Diffstat (limited to 'calc_test.go')
-rw-r--r--calc_test.go3
1 files changed, 3 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go
index 213f77a..283b9c2 100644
--- a/calc_test.go
+++ b/calc_test.go
@@ -385,6 +385,9 @@ func TestCalcCellValue(t *testing.T) {
"=TRUNC(-99.999,2)": "-99.99",
"=TRUNC(-99.999,-1)": "-90",
// Statistical functions
+ // COUNTA
+ `=COUNTA()`: "0",
+ `=COUNTA(A1:A5,B2:B5,"text",1,2)`: "8",
// MEDIAN
"=MEDIAN(A1:A5,12)": "2",
"=MEDIAN(A1:A5)": "1.5",