Count only instances where both yes and no

[Mitch_Data]

Hi,

I have a problem and I wish to know if anyone is able to help.

Problem:

I have calculation numbers like the screenshot below. For the value at the bottom of the table, 114286/1 and 114286/2 I have a question. As you can see the 114286/1 in the order column has 'lost' and 114286/2 has 'order'.

How can I make a formula that only counts the instances where a calculation number has both 'order' and 'lost'. I also made a column that seperates the calculation number from the " / " 

Further question: Then, how can I only count the calculation numbers that only have 'lost'. So for instance 114286 ranging from 114286/1 to 114286/10 can never have a 'order' in that range. 

o

[vinieme12 · Accepted solution]

=count( {<[CalculationnummerZonder]={"=count({<Order={'loss','order'}>}Distinct Order)=2"}>}Something)

OR

=count( {<[CalculationnummerZonder]=p({<Order={'loss'}>}[CalculationnummerZonder])*p({<Order={'order'}>}[CalculationnummerZonder])  

>}Something)

[Mitch_Data]

Fantastic @vinieme12 , this is the solution. Many thanks!