Count if + match with multiple criteria across couple sheets

Hi all,
I've got a problem and can't really figure it out the formula. I really hope You gonna understand what I'm trying to say.

I have a sheet which is called: Leave Tracker, in Row 7 i've got dates.
leavetracker.jpg

Then i have a second sheet which is called: Daily Staffing. The formula showed below counting me how many 'FT' codes are in column that matches with DailyStaffing B2.

Please Login or Register  to view this content.

daily staffing.jpg

Then i have a 3rd sheet thats called Employee Data, where i have all data of my users.
employee data.jpg

So i've figured it out how to count how many users are matching criteria (date and code "FT"), but I need to add a second criteria which is gonna be "CORE" from sheet Employee Data.

Any ideas how to solve it? I was trying to add a second INDEX,MATCH but as an output im getting only REF or SPILL.

Thank You all in advance!

After downloading, open the attachment and it will appear Password required

worksheet name : Daily Staffing

Try Cell C5 Array formula

HTML Code: