# Count if + match with multiple criteria across couple sheets

1. ## 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.

2. ## Re: Count if + match with multiple criteria across couple sheets

It's not exactly clear what you are trying to do, and screenshots are not much use to us as they can't be edited to play around with different formulae. It would be better to attach a sample Excel workbook, as described in the yellow banner at the top of the screen.

Hope this helps.

Pete

Hi Pete,

4. ## Re: Count if + match with multiple criteria across couple sheets

worksheet name : Daily Staffing

Try Cell C5 Array formula

HTML Code:

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1