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))

 

[Fluff]

Your formula works for me.

+Fluff v2.xlsm
	A	B	C	D	E	F
1
2			1
3
4		43050				x
5		43050				x
6		43050				x
7		43050				x
8		43050				x
9		43050				x
10		45065
11		45065
12		45065
13		45068				x
14		45068				x
15		45068				x
Main

Cell Formulas
Range	Formula
C2	C2	=SUM(--(FREQUENCY(IF(F4:F15="",B4:B15),B4:B15)>0))

 

[Legacy 469343]

I filled in all the cells as delivered, but it keeps saying 1 order is still pending?

 

[Fluff]

Do you have any hidden rows?

 

[Legacy 469343]

Do you have any hidden rows?

No hidden rows

 

[Fluff]

Does it make any difference if you use the table references like

=SUM(--(FREQUENCY(IF(Table4[Del. Com.]="",Table4[Orders]),Table4[Orders])>0))

 

[Legacy 469343]

Does it make any difference if you use the table references like

=SUM(--(FREQUENCY(IF(Table4[Del. Com.]="",Table4[Orders]),Table4[Orders])>0))

I get the following error when I enter your formula and hit SHIFT + CTRL + ENTER

 

[Fluff]

Did you change the table and column names to suit?

 

[Legacy 469343]

I changed the table name to Table1 instead of table4, since it's one table. Now it works, thanks!

 

[Fluff]

You're welcome & thanks for the feedback.