G'day Christy

This works as I have tested

Assumed you have 3 seperate column heading IN, TI, & OT

A B C
1 IN TI OT
2


A2 =SUMPRODUCT(AVERAGE(--($H13:$H36="IN"),$E13:$36))
B2 =SUMPRODUCT(AVERAGE(--($H13:$H36="TI"),$E13:$36))
C2 =SUMPRODUCT(AVERAGE(--($H13:$H36="OT"),$E13:$36))

HTH
Mark.