Sum based on drop downs across multiple sheets
I have multiple sheets that all lead to a "Totals" sheet on the first sheet.
This project is based on caseloads in a school system. Each "sheet" is its own school in the system. I have a drop-down on each sheet for the speech teacher for that school, as well as total hours of service time needed at each school/week.
I need to figure out how to show totals for each clinician on the "totals" sheet based on the dropdown selected (teacher's name), and total hours of service time for each school. I cannot wrap my head around this. I thought it was a SUMIF function (Sum the hours IF the dropdown says Mary will be the clinician), but can't get it to work across sheets and with the dropdown.
Help Article Resources
Check out the Formula Handbook template!