Hi!

What happens for the value 1? Counted in by te first expression and
counted out by the second.
Suggest second expression changes to COUNTI=ADF(A1:A11,""&1 ) i.e.
drop the "=3D"

Alf