=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

Mark Forums Read

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?

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 AM.