Count items in range
Very nice, I'm working hard in order to understand it. Could you give me some
guide to it?
Thanks,
Stefi
€˛Teethless mama€¯ ezt Ć*rta:
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
|