PDA

View Full Version : Solved: I am trying to count between two Values



hatched850
10-30-2006, 09:54 AM
:banghead: I have a list of values and I am trying to count the numbers between 6-10, 11-15, and so on. I can't get the function working any help would be appreciated.

Thank you
Debbie

Bob Phillips
10-30-2006, 09:56 AM
=COUNTIF(A:A,">=6")-COUNTIF(A:A,">10")

etc.

hatched850
10-30-2006, 10:08 AM
:beerchug: You are wonderful!!!!!! Thank you!!!!!! :thumb