Thread: [Solved] COUNTIF with multiple criteria
View Single Post
 
Old 02-16-2019, 11:06 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default COUNTIF with multiple criteria
Hi, I have a formula counting values with multiple criteria. It returns the correct value but the formula is quite looong. Is there a way to shorten it? I tried adding OR to remove the repetitive "REMARKS" but got error messages.


Code:
=COUNTIFS(SCHOOL_ID,$C$4,TRACK_STRAND,$F13,SEMESTER,$AD$4,SEX,J$11,DATE_ENROLLED,"<="&$AC$6,REMARKS,"<>"&"DRP",REMARKS,"<>"&"T/O",REMARKS,"<>"&"DIED",REMARKS,"<>"&"N/E",REMARKS,"<>"&"S/O")

Thank you.
Reply With Quote