COUNTIFS Formula with Multiple Criteria.

FPO

New member
Joined
Mar 9, 2020
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2016
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?
 

Attachments

  • FRB's Dashboard_for website.xlsm
    56.3 KB · Views: 12
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
 
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?
 
Yes, that solved the issue, thank you so much that is a life saver :)
 
Back
Top