Another attempt
See if attached can help...
Firstly, make a list of the unique principles in a row, e.g. in T1:U1 and under each principal enter the unique respectively assigned teachers.
Create
Then Data Validation for J3 would be to Allow: List and use source formula: =$T$:$U$1
Then Data Validation for J5 would be to Allow: List and use source formula:
Then Data Validation for M3:
You would need to adjust the ranges, etc, if more principals and teachers added.
Then in J8, summing formula would be:
=IF(OR($J$3="",$J$5="",$M$3=""),"",SUMIFS(INDEX($D:$G,0,ROWS($J$8:$J8)),C:C,$J$3,B:B,$J$5,A:A,$M$3))
copied down.
Bookmarks