COUNTIFS forumulas that can exclude criteria in a range

Good Morning,

I was wondering what I could add onto my existing formula below to exclude certain criteria of text in a column?

Currently, I am counting [element titles] "Encore at Platform" during the [Install date] date range of January 1 [R38] through January 31 [S38].

I now need to add more criteria to eliminate entries that were made in the column "Type of Branch" with the text (New Branch Opening 2016 and New Branch Opening 2017). Since these are future dates, I don't want to include them in my totals.


=COUNTIFS(Table_owssvr[Install Date],">="&Formulas!R38,Table_owssvr[Install Date],"<="&Formulas!S38,Table_owssvr[Element Title],"=Encore at Platform")

Try

=COUNTIFS("Table_owssvr[Install Date]",">="&Formulas!R38,"Table_owssvr[Install Date]","<="&Formulas!S38,"Table_owssvr[Element Title]","=Encore at Platform","Table_owssvr[Type of Branch]","<>New Branch Opening 2016","Table_owssvr[Type of Branch]","<>New Branch Opening 2017")

Hi Tony,

I tried the formula you suggested and I am getting an error message "The formula you typed contains an error". Could we possibly be missing an sign or something?

=COUNTIFS("Table_owssvr[Install Date]",">="&Formulas!R38,"Table_owssvr[Install Date]","<="&Formulas!S38,"Table_owssvr[Element Title]","=Encore at Platform",Table_owssvr[Type of Branch],"<>New Branch Opening 2016",Table_owssvr[Type of Branch],"<>New Branch Opening 2017")

I think the only issue was the quotation marks around the reference. Try this edited version of John's solution.

edit: If that still doesn't work, the first place I would look is to make sure the reference Table_owssvr[Type of Branch] is actually referencing the column it should.

try

=COUNTIFS(Table_owssvr[Install Date],">="&Formulas!R38,Table_owssvr[Install Date],"<="&Formulas!S38,Table_owssvr[Element Title],"=Encore at Platform",Table_owssvr[Type of Branch],"<>New Branch Opening 2016",Table_owssvr[Type of Branch],"<>New Branch Opening 2017")

Yippie! That worked perfectly.... I knew we were half way there. Thanks everyone for your help...

I am not sure how the erroneous quotes arose - so apologies _ but glad it's solved.