+ Reply to Thread
Results 1 to 3 of 3

How to do a multi conditional IF Function

  1. #1
    Registered User
    Join Date
    07-24-2016
    Location
    NY
    MS-Off Ver
    2013
    Posts
    1

    How to do a multi conditional IF Function

    Hello, I have been trying to figure out a method to compare two tables and return a count if two conditions are met

    I am trying to count how many times the 'Name' on Table A appears on Table B (if any) ONLY if the 'Date' on List B is within 6 months of Todays Date. I cannot figure out the syntax for this. Any ideas?!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to do a multi conditional IF Function

    Post some sample data and tell us what result you expect.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: How to do a multi conditional IF Function

    Suppose you data in two tables Table_A and Table_B and E3 the filter date
    Try to use
    =COUNTIFS(Table_B[Name],Table_A[@Name],Table_B[Date],">="&$E$3)

+ 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. Multi Conditional If Macro
    By clalle10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2015, 04:08 PM
  2. [SOLVED] Multi-Conditional Conditional Formatting and Dates
    By Mousiefuzz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2015, 04:09 AM
  3. Excel 2007 : Multi Conditional Sum
    By jesz1987 in forum Excel General
    Replies: 7
    Last Post: 10-19-2010, 06:38 AM
  4. Excel 2007 : Multi Conditional Sum
    By jesz1987 in forum Excel General
    Replies: 1
    Last Post: 10-14-2010, 06:51 AM
  5. Multi Conditional Sum
    By Brianboy_24 in forum Excel General
    Replies: 1
    Last Post: 09-08-2010, 05:40 PM
  6. Multi-Conditional with Wildcards...
    By Kianuz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-23-2009, 05:22 PM
  7. Multi-Conditional IF Statements
    By stacy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2006, 09:49 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