Spreadsheet: 862466d1710188249-sumif-changing-criteria-while-copying-down-formula-excel-forum-sum-if-criteria-question
Sheet: Non-Majors

TERM | PART_OF_TERM | TITLE | CREDITS | SUBJ | CRSE | SEC | INSTRUCTOR | BANNER_ID | STUNAME | MAJOR_1 | CLASS
Spring 2024 | 1 | Introduction to Music | 3 | MUS | 1030 | 1 | Instructor1 | A00773974 | Name, Student1 | BIOL | FR
Summer FtC | 1 | Introduction to Music | 3 | MUS | 1030 | W8 | Instructor2 | A00803391 | Name, Student2 | LIBA | JR
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | 5 | Instructor3 | A00802565 | Name, Student3 | ACCT | FR
Spring 1 FtC | 1 | Introduction to Music | 3 | MUS | 1030 | W0 | Instructor4 | A00818088 | Name, Student4 | SWRK | JR
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | 10 | Instructor5 | A00777319 | Name, Student5 | ACCT | SO
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | W1 | Instructor6 | A00785654 | Name, Student6 | LIBA | SO
Spring 2024 | 1 | Introduction to Music | 3 | MUS | 1030 | W0 | Instructor7 | A00786403 | Name, Student7 | LIBA | FR
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | W3 | Instructor8 | A00786532 | Name, Student8 | ACCT | FR
Fall 2023 | 1 | [NAME] | 1 | MUS | 1640 | 13 | Instructor9 | A00796646 | Name, Student9 | ACCT | SR
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | W0 | Instructor10 | A00786408 | Name, Student10 | LIBA | SO
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | 09H | Instructor11 | A00802174 | Name, Student11 | NURS | FR
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | 11 | Instructor12 | A00810476 | Name, Student12 | RDSC | FR
Spring 2024 | 1 | Introduction to Music | 3 | MUS | 1030 | 6 | Instructor13 | A00789788 | Name, Student13 | ACCT | SO
Spring 2 FtC | 1 | Introduction to Music | 3 | MUS | 1030 | W4 | Instructor14 | A00554584 | Name, Student14 | NURS | SO
Spring 2024 | 1 | Introduction to Music | 3 | MUS | 1030 | 10 | Instructor15 | A00665554 | Name, Student15 | ACCT | JR
Spring 2024 | 1 | Introduction to Music | 3 | MUS | 1030 | 6 | Instructor16 | A00787744 | Name, Student16 | ENGT | FR
Spring 2024 | 1 | Applied Clarinet LD | 1 | MUS | 1390 | 88 | Instructor17 | A00796646 | Name, Student17 | ACCT | SR
Spring 2024 | 1 | [NAME] | 1 | MUS | 1640 | 13 | Instructor18 | A00796646 | Name, Student18 | ACCT | SR
Spring 2024 | 1 | Clarinet Choir | 1 | MUS | 3760 | 12 | Instructor19 | A00796646 | Name, Student19 | ACCT | SR
Fall 1 FtC | 1 | Introduction to Music | 3 | MUS | 1030 | W0 | Instructor20 | A00766881 | Name, Student20 | LIBA | SR
Spring 2024 | 1 | Introduction to Music | 3 | MUS | 1030 | W1 | Instructor21 | A00497282 | Name, Student21 | CMIT | SR
Fall 2023 | 1 | [NAME] | 0 | MUS | 1060 | 10 | Instructor22 | A00325733 | Name, Student22 | AGRI | FR
Fall 2023 | 1 | [NAME] | 0 | MUS | 1060 | 10 | Instructor23 | A00325733 | Name, Student23 | AGRI | FR
Fall 2023 | 1 | Applied Voice LD | 1 | MUS | 1200 | 78 | Instructor24 | A00325733 | Name, Student24 | AGRI | FR
Fall 2023 | 1 | Popular World Music | 3 | MUS | 2200 | W1 | Instructor25 | A00813403 | Name, Student25 | BIOL | FR
Fall 2023 | 1 | University Choir | 1 | MUS | 1500 | 5 | Instructor26 | A00325733 | Name, Student26 | AGRI | FR
Fall 2023 | 1 | [NAME] | 1 | MUS | 1630 | 31 | Instructor27 | A00805474 | Name, Student27 | AGRI | FR
Fall 2023 | 1 | Introduction to Music | 3 | MUS | 1030 | W1 | Instructor28 | A00807953 | Name, Student28 | LIBA | FR
Fall 2023 | 1 | [NAME] | 1 | MUS | 1640 | 13 | Instructor29 | A00805474 | Name, Student29 | AGRI | FR
Fall 2023 | 1 | Opera Workshop | 1 | MUS | 1940 | 14 | Instructor30 | A00325733 | Name, Student30 | AGRI | FR