Count items in range
=SUMPRODUCT(--(IF(ISERROR(VALUE(B6:C9)),0,ABS(B6:C9)<100)))
as an array formula (Ctrl+Shift+Enter)
Regards,
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
|