def test_COUNTA_with_too_many_values(self):
self.assertIsInstance(
statistics.COUNTA([0] * 300), xlerrors.ValueExcelError)
def test_COUNTA_with_bad_arg(self):
self.assertIsInstance(statistics.COUNTA(None), xlerrors.NullExcelError)
def test_COUNTA_without_any_values(self):
self.assertIsInstance(statistics.COUNTA(), xlerrors.NullExcelError)
def test_COUNTA(self):
range0 = func_xltypes.Array([[1, 2], [3, 4]])
range1 = func_xltypes.Array([[2, 1], [3, '']])
self.assertEqual(statistics.COUNTA(range0), 4)
self.assertEqual(statistics.COUNTA(range1), 3)