+ Reply to Thread
Results 1 to 2 of 2

Count If across multiple critera

  1. #1
    Registered User
    Join Date
    08-11-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    4

    Count If across multiple critera

    Heyyyyy

    I have a list of data that has 2 columns - first columns in a bunch of dates, second columns is a bunch of countries.

    I need to write a formula, that counts the number of entries for a predefined date, and also where the country matches one of a range that I have written (e.g. if I want to count the number of european countries on April 4th).

    Hope that makes sense! If someone can help me with this that would be great as I am really struggling!!!

    Thanks
    Steve

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,943

    Re: Count If across multiple critera

    You could use Power Query to create a query that will count what you want - it's complicated, but doable.

    The easiest thing would be to use a third column (or as many columns as you need) to identify the group that each row belongs to, using formulas like this (assuming your dates are in A and the country is in B):

    =NOT(ISERROR(MATCH(B2,CountryList,False)))

    where CountryList is your 'range that you have written'

    Then copy that down to match, and use that column with COUNTIFS to count TRUE and date values from A.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Count Multiple Critera
    By morerockin in forum Excel General
    Replies: 3
    Last Post: 04-22-2017, 10:28 PM
  2. [SOLVED] Countifs (2 critera) but only once and do not count duplicates.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-26-2015, 08:10 PM
  3. Need a sum formual with 2 critera and count
    By Dial1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-24-2014, 04:07 PM
  4. Count across multiple columns with two critera
    By ucirsharma in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 01:26 PM
  5. Replies: 2
    Last Post: 01-14-2009, 04:01 AM
  6. Count with two critera
    By mwrfsu in forum Excel General
    Replies: 2
    Last Post: 08-01-2007, 09:14 PM
  7. Count if the the critera is met then half it
    By Joel in forum Excel General
    Replies: 5
    Last Post: 01-09-2006, 02:10 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