assertResult(c, "COUNTIF(A1:A5,\"apples\")", 2.);
assertResult(c, "COUNTIF(B2:B5,\">55\")", 2.);
}
public void testCOVAR() throws Exception {
AbstractFunction c = new COVAR();
assertEquals(
eval(c, toArray(3, 2, 4, 5, 6), toArray(9, 7, 12, 15, 17)), 5.2);
assertEquals(eval(c, toArray(3, ExprMissing.MISSING, 4, 5, 6), toArray(
9, 7, 12, 15, 17)), 3.375);
}