1 Reply Latest reply on Dec 15, 2016 6:16 PM by Ivan Young

    Simple Countif Function

    Angela.Koh

      Dear All

       

      I am having some problem with this formula - at a glance it looks okay and I can't figure out the problem with the formula.

      As you can see below, I would like to count the number of W2K that have Avg[QA]>=0.75 however the result is giving me a mixed response, here we can see (in red boxes) that the formula is not giving me counts of QA higher than 0.75 and even counting those with QA lower than 0.75.

      countifformulawrong.png

       

      Seek your expert help on this... Many thanks for your support!

       

       

      -Marcus