# Thread: COUNTIFS Formula with Multiple Criteria.

1. ## 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?

2. 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. 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. Hi,

It's in french. Please change it to COUNTIFS

Is it working ?

5. 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
•