Using CountIf to get values between two values

T

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
 
T

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
 
T

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
 
B

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)
 
Top