Count items in range
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
|