Adding an IF statement to an array

[DaRTH KiRo]

I am currently using the below array formula to pull information from another sheet. I want to add an if statement to this to only pull the data if Type equals "Employee". I have already done this with the other cells that are not arrays but cannot figure out how to make it work with this.

{=(INDEX(OTPerf[#All],MATCH(1,([@Name]='On-Time Performance'!C:C)*([@Month]='On-Time Performance'!B:B),0),36))}

Below is an example of the change I made to another cell.

=IF([@Type]="Employee",(SUM(H7,R7,I7)),"")

Could someone please help me figure out how to put this in place?

 

[etaf]

=IF([@Type]="Employee", (INDEX(OTPerf[#All],MATCH(1,([@Name]='On-Time Performance'!C:C)*([@Month]='On-Time Performance'!B:B),0),36)) ,"")
then set all as an array