- Feb 28, 2005
- 151
- 0
- 76
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
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