Try this:
None "Array" enter

=SUM(COUNTIF(B6:K300,{"-100","=100"})*{1,-1})


"Steven" wrote:

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