def test_SUMIFS_unequal_array_lengths(self):
self.assertEqual(
math.SUMIFS(
[10, 20, 30], [0, 1, 2], ">=1", ["a", "b", "a", 1], "a"
),
0
)
def test_SUMIFS(self):
self.assertEqual(
math.SUMIFS([10, 20, 30, 40],
[0, 1, 2, 3],
">=1",
["a", "b", "a", "A"],
"a"),
70
)
def test_SUMIFS_invalid_criteria(self):
self.assertIsInstance(
math.SUMIFS([10, 20, 30], [0, 1, 2], [0, 1], ["a", "b", "a"], "a"),
xlerrors.ValueExcelError)
def test_SUMIFS(self):
self.assertEqual(
math.SUMIFS([10, 20, 30], [0, 1, 2], ">=1", ["a", "b", "a"], "a"),
30)