Results 1 to 5 of 5

Thread: COUNTIFS Formula with Multiple Criteria.

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte FPO's Avatar
    Join Date
    Mar 2020
    Posts
    3
    Articles
    0
    Excel Version
    2016

    COUNTIFS Formula with Multiple Criteria.

    So here is my issue, in the attached spreadsheet, under the "Remedies" tab in Cell B3 I have my countifs formula. I am asking the formula to search for any instances between the dates of April 1 & April 30 that are in the tabs labeled "AJB, DMB, FTO, JJLK, KRA & TCM" and have the verbiage "Correspondence: Apology". But because the countifs formula needs all the criteria to be met before it will count, this is where I'm snagged. I need the formula to count how many instances of "Correspondence: Apology" appear in any of the tabs if the Date Closed is between April 1 & April 30th. How can I adjust my formula to do this?
    Attached Files Attached Files

  2. #2
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    112
    Articles
    0
    Excel Version
    365
    Hi,

    Can you try this formula :

    =NB.SI.ENS(AJB!$E:$E, ">=04/01/2020", AJB!$E:$E, "<=04/30/2020", AJB!$I:$I, "Correspondence: Apology") +
    NB.SI.ENS(DMB!$E:$E, ">=04/01/2020", DMB!$E:$E, "<=04/30/2020", DMB!$I:$I, "Correspondence: Apology") +
    NB.SI.ENS(FTO!$E:$E, ">=04/01/2020", FTO!$E:$E, "<=04/30/2020", FTO!$I:$I, "Correspondence: Apology") +
    NB.SI.ENS(JJLK!$E:$E, ">=04/01/2020", JJLK!$E:$E, "<=04/30/2020", JJLK!$I:$I, "Correspondence: Apology") +
    NB.SI.ENS(KRA!$E:$E, ">=04/01/2020", KRA!$E:$E, "<=04/30/2020", KRA!$I:$I, "Correspondence: Apology") +
    NB.SI.ENS(TCM!$E:$E, ">=04/01/2020", TCM!$E:$E, "<=04/30/2020", TCM!$I:$I, "Correspondence: Apology")

    Let us know if it works

    Hossat
    Algiers - DZ
    numidiabi.wordpress.com

  3. #3
    Neophyte FPO's Avatar
    Join Date
    Mar 2020
    Posts
    3
    Articles
    0
    Excel Version
    2016
    Thanks for the formula, but unfortunately it doesn't appear to be working. When I put that in, I get this "#NAME?" is there something I'm doing wrong? What is NB.SI.ENS?

  4. #4
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    112
    Articles
    0
    Excel Version
    365
    Hi,

    It's in french. Please change it to COUNTIFS

    Is it working ?

  5. #5
    Neophyte FPO's Avatar
    Join Date
    Mar 2020
    Posts
    3
    Articles
    0
    Excel Version
    2016
    Yes, that solved the issue, thank you so much that is a life saver

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •