I tried to mock something up, but I'm not sure that I caught the gist.
When you select an Academic Category, are you wanting the Support Hours
to be included only for that category, or across all categories?
Please adjust the workbook v10.3 and datasource attached in the Forum Thread
to more closely match yours.