Formula Help

I am trying to figure out how to sum a particular type of vacation leave for particular providers.  There are 9 different types of leave, minimum of 5 providers, and hours for each day of leave.  I n...