Thread: [Solved] =COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC")
View Single Post
 
Old 02-20-2018, 12:06 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
  
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default =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!D41008,"PC")
This works ok for just one condition

I need to add the following somehow...

=COUNTIFS(Netc!C4:C1008,"open" or "Waiting Parts",Netc!D41008,"PC")

or do I need to add separate countifs to do it?
Reply With Quote