diff options
| author | xuri <xuri.me@gmail.com> | 2021-12-14 00:38:16 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-12-14 00:38:16 +0800 |
| commit | c0ac3165bd8923efdaf95b377771d14f5879b1ec (patch) | |
| tree | 7087a9d8199f254ccf0f6ac64f9c42f4ab635fc9 /calc_test.go | |
| parent | 33719334945f0ce0752cedfbd4267b83850ab85d (diff) | |
ref #65: new formula function COUNTIFS
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 91e71d7..0544806 100644 --- a/calc_test.go +++ b/calc_test.go @@ -799,6 +799,9 @@ func TestCalcCellValue(t *testing.T) { "=COUNTIF(D1:D9,\"<>Jan\")": "5", "=COUNTIF(A1:F9,\">=50000\")": "2", "=COUNTIF(A1:F9,TRUE)": "0", + // COUNTIFS + "=COUNTIFS(A1:A9,2,D1:D9,\"Jan\")": "1", + "=COUNTIFS(F1:F9,\">20000\",D1:D9,\"Jan\")": "4", // DEVSQ "=DEVSQ(1,3,5,2,9,7)": "47.5", "=DEVSQ(A1:D2)": "10", @@ -2211,6 +2214,9 @@ func TestCalcCellValue(t *testing.T) { "=COUNTBLANK(1,2)": "COUNTBLANK requires 1 argument", // COUNTIF "=COUNTIF()": "COUNTIF requires 2 arguments", + // COUNTIFS + "=COUNTIFS()": "COUNTIFS requires at least 2 arguments", + "=COUNTIFS(A1:A9,2,D1:D9)": "#N/A", // DEVSQ "=DEVSQ()": "DEVSQ requires at least 1 numeric argument", "=DEVSQ(D1:D2)": "#N/A", |