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.
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!
Bookmarks