• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Help

T

thatguyant

Member
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top