Thanks Bob, now I see your point!

I think that we must use an array formula. I tried your normal formula
=SUMPRODUCT(--(B6:K300<""),--(ABS(B6:K300)<100))

but it returned #VALUE error because of not handling text cells.

Stefi

€žBob Phillips€� ezt Ã*rta:

If you are going to use an array formula, you might as well use SUM as
SUMPRODUCT

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stefi" wrote in message
...
Sorry, I forgot to mention that replace my test range with B6:K300
Stefi


"Steven" ezt Ã*rta:

I have numbers in range B6:K300 and also some text. I want to count the
number of occurances of cells with an absolute value of < 100.

Thank you,

Steven