Counting Grade Scores

[GmOOnii]

Hello.
I like to know if someone can make Excel 2007 formula that counts how many numbers they are between 90 to 99 like in the example chart below. If you have any questions please ask???
Thank you for your tips and help.

Grade Scores Chart to be fill out

67
100........... How many 100s are there? 1
97..... How many 90s to 99s are there? 1
60 .... How many 80s to 89s are there? 2
84 .... How many 70s to 79s are there? 1
73 .... How many 65s to 69s are there? 1
64 .....How many 60s to 64s are there? 2
86 ........................................Total of 8

[TMS]

=COUNTIFS(A1:A100,">=90", A1:A100,"<=99")

Adjust the range to suit.

Regards, TMS

[GmOOnii]

Wow, That was quick!
I was going to check tomorrow to see if I got any replies.
I will try your formula and tell you if it is the right one I needed.
Thank you for your help.

Edit1: Yup, that is what I needed. You just save me a lot have work. I have 25 different classes with 24 student scores in each to count so I can fill out that chart.

[GmOOnii]

Hello
I have one more question about formulas? Using the chart above, is there a way do find the max and min score?
Thank you for your help.

Max Score Obtained......Min Score Obtained
........100............................60

[TMS]

Like with MAX and MIN

[GmOOnii]

No way! That is too simply! Hee Hee
Thank you again.

[TMS]

You're welcome. Thanks for the rep.

[Cutter]

@ GmOOnii

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

[GmOOnii]

Ok, I will marked my thread as SOLVED. Thank you.