Microsoft Office Forums - View Single Post - [Solved] =COUNTIFS(Netc!C4:C1008,"open",Netcd!D4:D1008 ,"PC")

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

View Single Post

Old

02-20-2018, 05:13 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Try...

=SUM(COUNTIFS(Netc!C4:C1008,{"open","Waiting Parts"},Netc!D4: D1008,"PC")

Note: No space between the the colon and the D1008. The board is thinking the : and the D combined is a smiley face.

If you want a little explanation you'll find it here

Reply With Quote