Hi Team,
Need your help in understanding the countifs formula, when I give More Criteria in Array It gives different result.
Below formula gives Correct result.
=COUNTIFS($H:$H,"South",$I:$I,"NY",$J:$J,"Pending")
=SUM(COUNTIFS($H:$H,{"South","North"},$I:$I,"NY",$J:$J,"Finished"))
Here...