From b6dd7648a142901655cc4f76cb7d3a6e73338c8f Mon Sep 17 00:00:00 2001 From: xuri Date: Thu, 4 Jun 2020 00:35:54 +0800 Subject: fn: COUNTA --- calc_test.go | 3 +++ 1 file changed, 3 insertions(+) (limited to 'calc_test.go') 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", -- cgit v1.2.1