Unexpected COUNTIF behaviour

[Bobik]

Does anyone understand why COUNTIF is behaving the following way:

Row1: FALSE 1 1
Row2: FALSE 1 1
Row3: TRUE 2 1

with the formulas being:
Row1: FALSE =COUNTIF(A1:A3,A1:A3=FALSE
{=COUNTIF(A1:A3,A1:A3=FALSE)}
Row2: FALSE =COUNTIF(A1:A3,A1:A3=FALSE
{=COUNTIF(A1:A3,A1:A3=FALSE)}
Row3: TRUE =COUNTIF(A1:A3,A1:A3=FALSE
{=COUNTIF(A1:A3,A1:A3=FALSE)}

Looking at the non-array formulas - although the are all "exactly th
same" the formulas return different results depending on which row the
are in. This [for me unexpected] behaviour does not happen when enterin
the formulas as array-formulas

 

[Govind]

Hi,

You should use this non-array formula for countif

=COUNTIF(A1:A3,"FALSE")

Regards

Govind.

 

[Guest]

Hi
use
=COUNTIF(A1:A3,FALSE)