COUNTIF with multiple criteria

		Microsoft Office Forums > Microsoft Excel > Excel
COUNTIF with multiple criteria

FAQ

Thread Tools

Display Modes

02-16-2019, 11:06 PM

Marcia

Windows 7 32bit COUNTIF with multiple criteria

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use countif across multiple tabs for a column	marconexcel	Excel	6	02-21-2017 05:38 AM
COUNTIF [criteria] + give %	Tomas4	Excel	2	12-20-2016 10:28 AM
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached.	phillipsdp	Excel	1	11-09-2016 12:53 AM
Copy Multiple Rows to new workbook when multiple criteria is met.	flds	Excel Programming	5	09-30-2014 09:58 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:48 AM.