Excel Formula help, any alternate formula for Countifs

[Malleshg24]

Hi Team,
I am using below formula in excel, and getting Correct result,
Is there any alternate formula to get the same result here.

=SUM(COUNTIFS(H:H,{"North","South"},I:I,{"London";"NY"},$J:$J,"Finished"))

Thanks in advance for your help.

Regards,
mg

 

[herofox]

hello
please upload the file to be better to help You

 

[Peter Bartholomew]

There are other options such as SUMPRODUCT that might be a little more straightforward but the way you have combined the row and column arrays means that there unlikely to be more compact formulas.