Getting Percentage of All Records


#1

I have a simple table that lists student’s names, who their teacher is and what musical instrument they’re learning. How can I go about setting up a second sheet to calculate:

  1. percentage of students by teacher (i.e. what % of students does Jonas teach?)
  2. percentage of students by instrument (i.e. what % of students are learning piano?)

Ideally this would be able to account for students who take multiple lessons and have multiple teachers. Thanks in advance!