• 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.

Search results

  1. Y

    Countif in Array formula

    Hi Narayan, Thank you very much! It works but I have no idea how it does. Could you link me to anything that will take me through it. Thanks again Yasir
  2. Y

    Countif in Array formula

    Columns I to AG look like this: Balance P1 P2 P3 P4 P5 P6 551,112 1,972 2,155 2,338 2,521 2,704 2,887 949,129 668 851 1,034 1,217 1,400 1,583 2,701,536 183 366 549 732 915 1,098 89,394 1,946 2,129 2,312 2,495 2,678 2,861 56,013 2,201...
  3. Y

    Countif in Array formula

    Hi, I just started using array formulas and I'm having a problem with a slightly complicated one. The simplified version of the formula is: {=SUM(IF(S1!$B2:$B1000="20");S1'!$I2:$I1000*COUNTIF(S1!$J2:$AG1000;"<10"))} What the formula is basically supposed to do is...
Back
Top