+ Reply to Thread
Results 1 to 1 of 1

Count If with AND and Multiple OR conditions

  1. #1
    Registered User
    Join Date
    10-20-2020
    Location
    Australia
    MS-Off Ver
    O365
    Posts
    1

    Count If with AND and Multiple OR conditions

    Hi all,

    Need some assistance with a formula.

    Excel attached for sample data.

    I need a formula that counts the number of cells from Tab 1 and puts it in Tab 2 'B2' that match the following:

    1. Date (A2-A6) is within October 2020 (ie Oct-20), AND
    2. Status is either Received or "In Progress" or "Requested"

    So in this case the answer should be 3.

    Any assistance would be greatly appreciated.

    I am using O365.

    Rgds,
    AW 2020
    Attached Files Attached Files
    Last edited by AW2020; 10-20-2020 at 11:59 PM.

+ 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. How to count for multiple conditions.
    By amit_v31 in forum Excel General
    Replies: 2
    Last Post: 12-20-2014, 11:45 AM
  2. [SOLVED] Count IF Multiple conditions
    By buggzero in forum Excel General
    Replies: 4
    Last Post: 08-24-2012, 04:55 PM
  3. [SOLVED] Count multiple conditions
    By [email protected] in forum Excel General
    Replies: 5
    Last Post: 07-09-2012, 10:41 AM
  4. Count with Multiple Conditions
    By george_g in forum Excel General
    Replies: 5
    Last Post: 03-27-2011, 04:44 AM
  5. Re: How to use count with multiple conditions
    By simmonsmtb31 in forum Excel General
    Replies: 1
    Last Post: 08-05-2009, 04:09 PM
  6. Count unique logs with multiple conditions of multiple sheets
    By Robert Bob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-12-2007, 12:49 AM
  7. [SOLVED] Count with multiple conditions
    By Toby0924 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2005, 10:06 AM

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