• 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


  • 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


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.


Thanks in advance for your help.


Peter Bartholomew

Well-Known Member
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.