|
|
#7
02-22-2018, 03:51 AM
|
|||
|
|||
Yes you can use a list, but to do that you will now need to wrap the Countifs in Sumproduct.
=SUMPRODUCT(COUNTIFS(Netcard!$C$4:$C$20,$F$1:$F$2, Netcard!$D$4:$D$20,"Kiosk Assembly")) F1:F2 = Waiting Parts and Open BTW: In the file you attached, you did not have the Countifs wrapped in Sum. It must be wrapped in order for the OR operation to take effect. 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows Vista 
Office 2007
Threaded Mode