+ Reply to Thread
Results 1 to 7 of 7

Combining multiple COUNTIF statements

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    Iowa, USA
    MS-Off Ver
    O365
    Posts
    6

    Combining multiple COUNTIF statements

    I am able to use =Countif('CORE Process Audit data'!$D:$F,G5) and =COUNTIFS('CORE Process Audit data'!$G:$G,"<="&TODAY(),'CORE Process Audit data'!$G:$G,">="&TODAY()-30) separately, but I cannot figure out how to use them in one COUNTIFS statement.
    Last edited by AliGW; 01-27-2021 at 11:44 AM. Reason: SOLVED tag added - no need to edit the thread title!!!

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Combining multiple COUNTIF statements

    Offer SUMPRODUCT, not refer to whole range

    Please Login or Register  to view this content.
    If it does not work, try to upload a samle spreadsheet.
    Quang PT

  3. #3
    Registered User
    Join Date
    01-25-2021
    Location
    Iowa, USA
    MS-Off Ver
    O365
    Posts
    6

    Re: Combining multiple COUNTIF statements

    On the CORE Process Audits tab, I need B5 to pull the number of audits that match the label in G5 in columns D, E, or F in the CORE Process Audit data tab as well as have a Created date 'CORE Process Audit data'!$G$:$G) within the last 30 days.
    Attached Files Attached Files

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Combining multiple COUNTIF statements

    I try the formula and it returns 7, exactly with test result (from 28/12/2020-27/01/2021)

    What is your desired result?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-25-2021
    Location
    Iowa, USA
    MS-Off Ver
    O365
    Posts
    6

    Re: Combining multiple COUNTIF statements

    This is perfect! Thank you so much for the help.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: [SOLVED] Combining multiple COUNTIF statements

    To mark a thread as solved, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    You do not need to edit the post title.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Registered User
    Join Date
    01-25-2021
    Location
    Iowa, USA
    MS-Off Ver
    O365
    Posts
    6

    Re: [SOLVED] Combining multiple COUNTIF statements

    Thanks for the help!

+ 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] Combining IF with multiple COUNTIF statements
    By smgrossie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-31-2020, 02:58 PM
  2. Combining mutiple IF and CountIF statements to help sort data
    By frekemeister in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2013, 07:33 AM
  3. [SOLVED] Combining multiple IF THEN statements
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2013, 02:04 AM
  4. Excel 2007 : combining two countif statements
    By stephsmom in forum Excel General
    Replies: 7
    Last Post: 02-23-2012, 04:49 PM
  5. combining two countif statements
    By stephsmom in forum Excel General
    Replies: 3
    Last Post: 02-23-2012, 12:51 PM
  6. Combining Multiple IF Statements
    By prefcomm in forum Excel General
    Replies: 2
    Last Post: 11-11-2009, 11:35 PM
  7. Combining COUNTIF statements with different criteria
    By Darlo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2007, 02:32 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