Hey there folks. I am wondering how to state the criteria in the COUNTIF
function to find values higher than one number and lower than another. Thank
you.

One way:

=SUMPRODUCT(--(A1:A102),--(A1:A10<10))

another

=COUNTIF(A1:A102) - COUNTIF(A1:A10<=10)

In article ,
"etan" wrote:

Hey there folks. I am wondering how to state the criteria in the COUNTIF
function to find values higher than one number and lower than another. Thank
you.

Thank you.

"JE McGimpsey" wrote:

One way:

=SUMPRODUCT(--(A1:A102),--(A1:A10<10))

another

=COUNTIF(A1:A102) - COUNTIF(A1:A10<=10)

In article ,
"etan" wrote:

Hey there folks. I am wondering how to state the criteria in the COUNTIF
function to find values higher than one number and lower than another. Thank
you.

You meant of course:

=COUNTIF(A1:A10,"2") - COUNTIF(A1:A10,"10")

JE McGimpsey wrote:
One way:

=SUMPRODUCT(--(A1:A102),--(A1:A10<10))

another

=COUNTIF(A1:A102) - COUNTIF(A1:A10<=10)

In article ,
"etan" wrote:


Hey there folks. I am wondering how to state the criteria in the COUNTIF
function to find values higher than one number and lower than another. Thank
you.

No,

=COUNTIF(A1:A10,"2") - COUNTIF(A1:A10,"=10")

is what I meant. But yours was closer than mine.


In article ,
Aladin Akyurek wrote:

You meant of course:

=COUNTIF(A1:A10,"2") - COUNTIF(A1:A10,"10")

Funny, since I started to use Thunderbird as mail-client and
news-reader, which is just great, I'm constantly missing a letter or two
in my typing. A great excuse no? <g

I actually wanted to write about the CountIf idiom that it's faster than
the equivalent SumProduct formula. That is, whenever a numerical
in-between condition is involved, it wouldn't a bad idea to invoke this
CountIf idiom. And SumIf for summing...

JE McGimpsey wrote:
No,

=COUNTIF(A1:A10,"2") - COUNTIF(A1:A10,"=10")

is what I meant. But yours was closer than mine.


In article ,
Aladin Akyurek wrote:


You meant of course:

=COUNTIF(A1:A10,"2") - COUNTIF(A1:A10,"10")