CountIf

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello,
Using Excel XP, I would like to count the number of occurences that fall
between two numbers. For example, I would like to count how many occurences
that are between 5 and 10 in A1:A7. I tried =COUNTIF(A1:A7,">=5,<=10 ")
but it does not return the correct value. Any help would be appreciated.
Mike

A
------------------------------
1 4
2 6
3 12
4 17
5 3
6 8
7 1
 
Hi Mike.......

You were given two answers that worked in less than 30 minutes after your
original post. But, it's even "more-better-great" that you were able to
figure it out for yourself. Sometimes all it takes to make you see things
more clearly is to try to verbalize your problem to someone else. That's
just another benefit of these fine Newsgroups.

Thanks for letting us know you figured it out..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top