This is the data set I have OrderStatusType1 Ship1ClosedReturn1ClosedShip 3PL1ClosedReturn 3pl2ClosedShip2ClosedReturn2ClosedShip 3PL2ClosedReturn 3pl3ClosedShip3ClosedReturn4 Ship4ClosedReturn I would like to be able to add a new column that would count the orders that have all Status "Closed" for the order. So Order 2 and 3 are the only ones that would be counted. Order 1 and 4 would not count because there are statuses with nothing.

If Statement, Count, and Group By

This is the data set I have

I would like to be able to add a new column that would count the orders that have all Status "Closed" for the order.

So Order 2 and 3 are the only ones that would be counted.

Order 1 and 4 would not count because there are statuses with nothing.

Workflow

Here's one way if you want to keep all records but only show a count of 100% closed orders:

Another option with reduced tools (v2):

Not sure exactly what you want the output to look like for the example?

Kind regards,

Jonathan

Here's an attached solution which keep only orders without occurrences of null status.

Let me know if it works as you want.

Cheers !

Here's one way if you want to keep all records but only show a count of 100% closed orders:

Another option with reduced tools (v2):

Here is my solutions. If i am not wrong, you need 1 and 4 as well in the output without count. Is it correct?

@ashleyinman one way of dong this