+ Reply to Thread
Results 1 to 4 of 4

Count Based On Multiple Criteria

  1. #1
    Registered User
    Join Date
    01-18-2012
    Location
    Wigan, England
    MS-Off Ver
    Excel 2016
    Posts
    14

    Count Based On Multiple Criteria

    Hi all,

    I'm in dire need of some assistance please.

    On the attached i'm looking for a count based the date/transport related issue looking at the 'Del Issues' tab, I've added an example of how i'd like it to look in column B.

    For example, there was 1 transport planning issue on 10/02/20 so 1 is in cell B3

    I hope this makes sense, thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Count Based On Multiple Criteria

    this would be one way...
    =COUNTIFS('Del Issues'!C:C,A2,'Del Issues'!G:G,$I$2)+COUNTIFS('Del Issues'!C:C,A2,'Del Issues'!G:G,$I$3)+COUNTIFS('Del Issues'!C:C,A2,'Del Issues'!G:G,$I$4)+COUNTIFS('Del Issues'!C:C,A2,'Del Issues'!G:G,$I$5)+COUNTIFS('Del Issues'!C:C,A2,'Del Issues'!G:G,$I$6)+COUNTIFS('Del Issues'!C:C,A2,'Del Issues'!G:G,$I$7)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    01-18-2012
    Location
    Wigan, England
    MS-Off Ver
    Excel 2016
    Posts
    14

    Re: Count Based On Multiple Criteria

    Thanks so much for your quick response, it does the job!!

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Count Based On Multiple Criteria

    Glad that worked for you, AND thank you for the rep!

+ 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. Replies: 1
    Last Post: 02-09-2017, 05:55 PM
  2. Count based on multiple criteria
    By yggdrasil52 in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 10-24-2014, 03:27 PM
  3. [SOLVED] Count and sum based on multiple criteria
    By Exceltrouble in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2012, 04:27 AM
  4. Count Based on Multiple Criteria
    By jaexcel in forum Excel General
    Replies: 5
    Last Post: 06-07-2012, 02:25 PM
  5. [SOLVED] Need Count based on Multiple Criteria
    By sureshpillitla in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2012, 02:47 AM
  6. Count based on multiple criteria
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2011, 02:57 PM
  7. Count Multiple Entries, Return Multiple Rows, Based On 3 Criteria
    By gtj_global in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2008, 06:40 PM

Tags for this Thread

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