I cant.. I tried your option..

countif uses microsofts "standard" criteria argument.. which makes it
flexible but in this case too flexible.

So I tried something else & posted it.
While working with arrays I often use the N() function to force an array
of true/false/missing to numbers only..


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Kris" wrote:

That actually fixed the problem. Thank you very much. Would you mind
quickly explaining why this works and why the other method doesn't
work? Thanks!

kris


"keepitcool" wrote in message
...
try:

=SUM(N(A1:A100="1.1"))
entered as array (ctrl-shift-enter)

keepITcool