3 Replies Latest reply on Dec 14, 2016 11:10 PM by Mahfooj Khan

    Countif + Countd Function Combination?

    Angela.Koh

      Dear All

       

      Basically, I want to countd the number of [W2k] that exceeded 700 [AHT].

      Is there any formula that will allow me to do that?

       

      countd.png

      I have tried countd (if [AHT] >= 700  THEN [W2K] end) but the result is not correct... (Showing me 318 instead of 244)

      countd(wrong).png

      I think countd (if AVG([AHT]) >= 700  THEN [W2K] end) would work but I was prompted with this error "You cannot mix aggregated with non-aggregated..."

      I have attached the workbook here.

       

       

      Many thanks for your help:)

       

      Regards

      Marcus