From c0ac3165bd8923efdaf95b377771d14f5879b1ec Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Tue, 14 Dec 2021 00:38:16 +0800
Subject: ref #65: new formula function COUNTIFS

---
 calc_test.go | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'calc_test.go')

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",
-- 
cgit v1.2.1