+ Reply to Thread
Results 1 to 2 of 2

How to create a countif index match formula

  1. #1
    Registered User
    Join Date
    06-25-2011
    Location
    Boston
    MS-Off Ver
    Excel 2007
    Posts
    25

    How to create a countif index match formula

    Hey,

    I'm familiar with countifs, index/matches, but have been having trouble combining them. I have 4 criteria, one which is a date, with the day if the week over it.
    In the columns AA to AG is the weekday Sunday to Saturday. Below them I have them extending to 1200 rows with data criteria, I have more criteria in column K (dates) and H is another criteria. How would I combine it? I need it to look for the day if the week, then match the number of occurrences below of a criteria along with matching the date occurrences in K, and other criteria in H.
    Sorry for not having a table or sheet attached

    Thanks
    Mzing81

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: How to create a countif index match formula

    Without a workbook with your actual set up, it is practically impossible to help you.
    Can you attach a sample workbook? It could be a small sample of data or similar data if you are using sensitive ones.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

+ 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] is it possible to insert IF condition in Index March formula
    By Imran Magsi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-09-2016, 07:52 AM
  2. Index March a specific part of table
    By metal.stuff in forum Excel General
    Replies: 1
    Last Post: 06-24-2016, 08:38 AM
  3. [SOLVED] Please i need help. INDEX MATCH + COUNTIF Formula
    By windtalkers26 in forum Excel General
    Replies: 7
    Last Post: 01-09-2016, 11:39 AM
  4. [SOLVED] Index match formula with countif ?
    By gaftalik in forum Excel General
    Replies: 12
    Last Post: 04-08-2015, 06:03 AM
  5. [SOLVED] Help with countif & index formula
    By lvsmr2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2013, 01:18 AM
  6. [SOLVED] Countif & Index formula
    By sumonrezadu in forum Excel General
    Replies: 6
    Last Post: 08-28-2009, 10:10 AM
  7. [SOLVED] March 2005 Actual Info vs March 2006 Plan Info
    By Al in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2005, 03:06 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