Using CountIf to get values between two values

[THOMAS CONLON]

Can CountIf be used to get values between two values? All the examples use
criteria like ">30","<20", etc. How would you count values between 10 and
100, say? I tried a few guesses at syntax but none of them worked.
Thanks
tom

 

[Ardus Petus]

Use SUMPRODUCT:

=SUMPRODUCT((A1:A999>=10)*(A1:A999<100),B1:B999)

HTH

 

[THOMAS CONLON]

Cool, its a nice "trick". Too bad COUNTIF directly with an intuitive syntax
doesn't do it, but this works, so great! Thanks much!
tom

 

[THOMAS CONLON]

oops, i responded too fast. Didin't see the range b1:b999 in the argument.
What is in the B range? Assume the data that i want to count between 10 and
100 is in a1:a999.
Thanks
tom

 

[Guest]

=COUNTIF(A:A,"<=100")-COUNTIF(A:A,"<=10")

Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

=SUMIF(A:A,">=10")-SUMIF(A:A,">=100")

if you want to sum those numbers in the range,

=COUNTIF(A:A,">=10")-COUNTIF(A:A,">=100")

to count them

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)