=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, 05:13 PM

jeffreybrown jeffreybrown is offline

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

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

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

« Previous Thread | Next Thread »

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 11:26 PM.