+ Reply to Thread
Results 1 to 4 of 4

Count if + match with multiple criteria across couple sheets

  1. #1
    Registered User
    Join Date
    11-29-2020
    Location
    Middlewich
    MS-Off Ver
    365
    Posts
    19

    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!
    Attached Files Attached Files
    Last edited by Komarov; 09-16-2021 at 09:02 PM. Reason: Added sample sheet.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,785

    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

  3. #3
    Registered User
    Join Date
    11-29-2020
    Location
    Middlewich
    MS-Off Ver
    365
    Posts
    19

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

    Hi Pete,
    I've added a sample workbook.

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,250

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

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

    worksheet name : Daily Staffing

    Try Cell C5 Array formula

    HTML Code: 
    Last edited by wk9128; 09-17-2021 at 10:51 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to count matches between multiple columns on different sheets w/ multiple criteria
    By RICK JAMES in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2019, 03:28 PM
  2. Count w/multiple criteria across multiple columns - SUMPRODUCT, MATCH?
    By MrHoohah in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2015, 05:23 PM
  3. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  4. Replies: 0
    Last Post: 01-11-2013, 02:39 AM
  5. Replies: 8
    Last Post: 07-13-2012, 06:00 AM
  6. Count - multiple criteria, multiple sheets, and date range.
    By threecliffs in forum Excel General
    Replies: 6
    Last Post: 06-14-2011, 01:36 PM
  7. Match count multiple criteria
    By gvanstone in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-21-2010, 09:30 PM

Bookmarks

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