Thread: [Solved] =COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC")
View Single Post
 
Old 02-21-2018, 05:18 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
Thanks but I had tried that already and it didn't work, it only found the first variable, I even swapped them to confirm this.

I think I'll go with using the above single variable and add extra countifs with a "+" in between to get the result I need. seems to work ok.

=COUNTIFS(Netc!C4:C1008,"open",Netc!D41008 ,"PC") + COUNTIFS(Netc!C4:C1008,"waiting parts",Netc!D41008 ,"PC")
Reply With Quote