HI, I try to replicate an example about COUNTIF (from Excel help) as
follows:

Suppose A3:A6 contain "apples", "oranges", "peaches", "apples",
respectively:

COUNTIF(A3:A6,"apples") equals 2

If I use menu Insert/Function, then fill in countif dialog box, i.e.
=COUNTIF(A3:A6;"apples"), it ends up 0 which is NOT correct.

If I type =COUNTIF(A3:A6;"apples") in some cell, it ends up a windows
saying that the formula typed contains an error.

I desperately need your advice, as I tried hundreds of times, no any
clue on what is wrong. Thanks.


--
bjg
------------------------------------------------------------------------
bjg's Profile: http://www.excelforum.com/member.php...o&userid=16776
View this thread: http://www.excelforum.com/showthread...hreadid=320037