#1
|
|||
|
|||
Nested Countif Function
Everything is explained in the excel file but here is a sneak peak of it:
I have most of the formulas down i just need to put them all together... HTML Code:
Component Type/Operation Status/Order Status/ID # 64 in queue active DU1H3333 64 in queue active DU1H3334 64 in queue active DU1H3333 60 in queue stop DU1H3336 60 active stop DU1H3337 60 hold stop DU1H3338 60 active stop DU1H3337 64 in queue active DU1H3340 64 in queue active DU1H3340 64 active active DU1H3342 I am trying to count the # of components with component type "64", operation status "in queue" or "active", order status "active" and the ID #'s cannot be the same The answer for this example is 4 I have thousands of components that the function will search through. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Countif with filter | epnhakon | Excel | 3 | 08-29-2014 09:46 AM |
Countif function not calculating correctly | MoranGail | Excel | 1 | 07-09-2014 05:50 AM |
Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |
Countif with 2 criteria | ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
Nested IFs | JimS378 | Excel | 7 | 05-03-2011 08:20 PM |