Count items in range
I tried it and it worked with SUM function but not simply, only when entered
as an array formula.
Stefi
Bob Phillips ezt *rta:
I see why you did it now (I must admit to wondering about that), but I would
use ISNUMBER, then it simply becomes
=SUM(IF(ISNUMBER(B6:C9),IF(ABS(B6:C9)<100,1)))
the intent is nice and clear then.
--
__________________________________
HTH
Bob
"Stefi" wrote in message
...
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
|