=COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC")

		Microsoft Office Forums > Microsoft Excel > Excel
=COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC")

FAQ

Thread Tools

Display Modes

02-20-2018, 12:06 PM

trevorc

Windows 7 32bit =COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC")

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

=COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC")

Hi All,
I need to add some extra conditions to the formula below, any ideas as to how this is done would be great.

=COUNTIFS(Netc!C4:C1008,"open",Netc!D4

1008,"PC")
This works ok for just one condition

I need to add the following somehow...

=COUNTIFS(Netc!C4:C1008,"open" or "Waiting Parts",Netc!D4

1008,"PC")

or do I need to add separate countifs to do it?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine "sort within groups" and "identify duplicate/unique values" in two different variables.	civilcervant	Excel	3	06-12-2017 07:27 AM
"Open Recent" and "More..." in Excel and Word	BudVitoff	Office	0	04-03-2015 09:17 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas	jocke321	Word VBA	2	12-10-2014 11:27 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM