COUNTIF with multiple criteria

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

FAQ

Thread Tools

Display Modes

02-17-2019, 05:12 AM

Marcia

Windows 7 32bit COUNTIF with multiple criteria

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 554

Quote:

Originally Posted by ArviLaanemets

I suspect you may want to filter on specific strings in Remark field. When this is case, you have to make the hidden column dynamic based on come general counting criteria you/user select(s) on worksheet.

You're correct Arvi, I want the countif formula to include all remarks except "DRP", "T/O", "DIED", "N/E" and "S/O".

« 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 11:19 AM.