Excel Help

[thatguyant]

Hi everyone,

I'm trying to summarize some data and I'm wondering if a sumif is the right solution. Here's a sample data set:

Room Name Grade
201 John 70
201 Jim 80
201 Nancy 70
202 Mary 60
202 Ralph 70
etc..

I need to make a chart that that will list the room and how many of each grade. For example:

Room Grade 60 Grade 70 Grade 80
201 0 2 1
202 1 1 0

Any ideas?

Thanks