Post by sacteach on May 26, 2015 1:57:56 GMT
I'm slowly learning more and more about Excel and trying to take advantage of its features. Here is my situation.
My 8th grade BBQ is this Wednesday. I have an excel spreadsheet with the following data: Student Name, ID number, Period 4 teacher, Food selection (hamburger, hot dog, veggie burger, etc)
I've sorted the spreadsheet by Period 4 teacher, then by food. Each teacher will get a printout of their class and will give the students different colored wristbands based on their food choice. Each class obviously has a different number of hamburgers, hot dogs, etc.
Is there an easy way to do a count on each sheet of the number of each item: Mrs. Smith: Hot Dogs = 2, Hamburgers = 7, etc. Mr. Jones: Hot Dogs = 5, Hamburgers = 12, etc.
I figured out how to do a total count of each item, but I'd like it broken down by teacher (each teacher is on a separate page) if possible. If not, I can just draw lines and put the number next to the column like I did last year, but if there is an easier way, that would be great!
My 8th grade BBQ is this Wednesday. I have an excel spreadsheet with the following data: Student Name, ID number, Period 4 teacher, Food selection (hamburger, hot dog, veggie burger, etc)
I've sorted the spreadsheet by Period 4 teacher, then by food. Each teacher will get a printout of their class and will give the students different colored wristbands based on their food choice. Each class obviously has a different number of hamburgers, hot dogs, etc.
Is there an easy way to do a count on each sheet of the number of each item: Mrs. Smith: Hot Dogs = 2, Hamburgers = 7, etc. Mr. Jones: Hot Dogs = 5, Hamburgers = 12, etc.
I figured out how to do a total count of each item, but I'd like it broken down by teacher (each teacher is on a separate page) if possible. If not, I can just draw lines and put the number next to the column like I did last year, but if there is an easier way, that would be great!
