Countif

[kiki443]

I'm trying to count a range of number that appear in a column. How can I do this?

I currently need to count the number of times any number in the range of 31-60 appears.
[/i]

 

[MrActuary]

=countif(A1:A100,">30")-countif(A1:A100, ">60")

 

[kiki443]

I've tried that but the actual count is off. It's counting everything less than instead of stopping at the starting # which is 31 in this case.

 

[kiki443]

Forget it, I didn't put the right range, that's what I get for being excited about getting great help.

Thank you so it worked like a charm.