• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Formula help, any alternate formula for Countifs

Malleshg24

New Member
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
 
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.
 
Back
Top