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")