Count items in range
=SUMPRODUCT(--(B6:K300<""),--(ABS(B6:K300)<100))
--
__________________________________
HTH
Bob
"Steven" wrote in message
...
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
|