Do you mean all except when [@Remark] is "DRP" OR "T/O" OR "DIED", "N/E" OR "S/O"?
Or you mean all except when [@Remark] contains "DRP" OR "T/O" OR "DIED", "N/E" OR "S/O"?
Depending on your answer, the formula in additional column (e.g. RemarkGroup) in Table tSource will be:
(I assume you have defined the data table as Table (e.g. tSource). Otherwise you have to edit the formulas to use regular worksheet references. And I assume the final formula doesn't belong into Table tSource.)
Code:
= ([@Remark] = "DRP") + ([@Remark] = "T/O")+ ([@Remark] = "DIED")+ ([@Remark] = "N/E")+ ([@Remark] = "S/O")
or
Code:
= (Find("DRP",[@Remark]) >0) + (Find("T/O",[@Remark]) >0)+ (Find("DIED",[@Remark]) >0)+ (Find("N/E",[@Remark]) >0)+ (Find("S/O",[@Remark]) >0)
The final formula will be
Code:
=COUNTIFS(tSource[SCHOOL_ID],$C$4,tSource[TRACK_STRAND],$F13,tsource[SEMESTER],$AD$4,tSource[SEX],J$11,tSource[DATE_ENROLLED],"<="&$AC$6,tSource[RemarkGroup],0)