Combine SUM FREQUENCY IF formula

[Legacy 469343]

Hi, what formula do I need to show the amount of unique orders, linked to location 18 and delivered or not?
The formula used for unique orders: =SUMPRODUCT(((ISNUMBER(A4:A25))/COUNTIF(A4:A25;A4:A25&"")))
The formula used for location 18 (SHIFT+CONTROL+ENTER):
=SUM(--(FREQUENCY(IF(C4:C25=C4;A4:A25);A4:A25)>0))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUM(--(FREQUENCY(IF(C4:C25=C4;if(D4:D25="Yes";A4:A25));A4:A25)>0))

 

[Legacy 469343]

Hi & welcome to MrExcel.
How about

=SUM(--(FREQUENCY(IF(C4:C25=C4;if(D4:D25="Yes";A4:A25));A4:A25)>0))

That did the trick! Thanks a lot!

 

[Fluff]

You're welcome & thanks for the feedback.