Combine SUM FREQUENCY IF formula with multiple IFS

[Legacy 469343]

How can I ensure that pending orders are set to 0 once all items of the same order from the same company have been delivered? As you can see I have marked all items as delivered in column F, but 1 order remains open as pending?

Formula used in pending orders is: =SUM(--(FREQUENCY(IF(F4:F15="",B4:B15),B4:B15)>0))

 

[Legacy 469343]

You're welcome & thanks for the feedback.

Unfortunately, it's not doing what I want... I need the Delivered Orders to count one PO is all the items of one PO have an X in the del. com. colom. Is this possible?

 

[Fluff]

Is this possible?

Very possibly, but as this is a different question & I don't know how, youl'd best start a new thread.